Sunday, February 10, 2013 5:39 AM
I have a SSIS package. I load .dtsx file to integration Service Server from local computer, but do not know how to upload the configuration file from local computer to Server. I want to add the configuration file to job step.
Sunday, February 10, 2013 6:45 AM
You have to do package configuration & deployment procedure ,once you develop your package.
Refer this link - http://msdn.microsoft.com/en-us/library/ms137592.aspx
hope this link will help you!!!
After successful deployment ,go to \bin\deployment folder,double-click the Integration Services Deployment Manifest file,
then you have two options to deploy your package in your server - File system & SQL Server deployment.
Thanks & Regards, sathya
- Edited by SathyanarrayananS Sunday, February 10, 2013 7:06 AM
- Proposed As Answer by SSISJoostMicrosoft Community Contributor, Moderator Sunday, February 10, 2013 9:46 AM
Sunday, February 10, 2013 9:49 AMModerator
Creating a Deployment Utility is probably the easiest way:
Monday, February 11, 2013 7:48 PM
The Deployment Utility install the .dtsx and .dtsConfig files to my local computer if I select File System.
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\jobTest
The Deployment Utility install the .dtsx file to target server, but install the dtsConfig file to my local computer if I select SQL Server.
Could you please give me more details. Thank you very much!
- Edited by SarahLiu Monday, February 11, 2013 8:06 PM
Monday, February 11, 2013 8:46 PMModerator
Monday, February 11, 2013 9:09 PM
I am new bee for SSIS.
One more question, if I create the SQL Server configuration file. All of data is saved in table SSIS_Configuration, then how to add the configuration file to the job step, Or do not need add it to the job step, because it already exist in the SQL Server?
- Edited by SarahLiu Tuesday, February 12, 2013 4:17 PM
Wednesday, February 13, 2013 7:29 AMModerator
You can click the Configurations tab on the SQL Server Agent to add configuration files, please refer to detail steps: http://stackoverflow.com/questions/6712811/how-do-i-create-a-step-in-my-sql-server-agent-job-which-will-run-my-ssis-package/6713464#6713464
For more information about running a package by using a SQL Server Agent job, please see: http://msdn.microsoft.com/en-us/library/ms138023(v=sql.100).aspx
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 3:06 AM