May 25, 2011 at 8:05 am
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.
May 25, 2011 at 8:22 am
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
May 25, 2011 at 8:51 am
Read about XML Configuration files. It makes the job when moving SSIS from dev to prod.
May 26, 2011 at 9:24 am
use "localhost" in your connection
🙂
May 27, 2011 at 12:19 am
darth_vodka (5/26/2011)
use "localhost" in your connection🙂
Let'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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply