SSIS DTSX file and config file
-
Hello All,
i am new be in ssis so please just bear with me.
i am a bit confused with the ssis DTSX file and config file.
how will i move the ssis dtsx file form the dev to production.
i den has given me a DTSX file to run on server b. it was designed on server A ( the dtsx file connect to database on server A named test).
on the server B i have to run this package with the database test on server B.
i am confused as how to change connection at run time using Config files.
i know how to open the package use deployment utiltiy and run it, change the connections in the BDIS and deploy it on server B, but for the life of me i cant figure out how to use the config file.
this what i have done so far .
i downloaded ( moved the DTSX file to server B, than on connected to the SSIS through SSMS and open file system and did import package.
now i see my imported package on the file system list but now how will i see the config file , where is it or i need to create one.
please help.
-
I take it you have BIDS on your desktop? If you search the internet for "creating a deployment manifest" you should find plenty of content on how to deploy your package with the correct configuration.
John
-
Read about XML Configuration files. It makes the job when moving SSIS from dev to prod.
-
use "localhost" in your connection
-
darth_vodka (5/26/2011)
use "localhost" in your connectionLet's hope they do not work with named instances
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply