December 24, 2008 at 4:52 am
Hi
I created the SSIS package for my solution. I am pulling the data from different servers and inserting in another server using script . In the package , I m using file connection for the script files .
Now, I want to pass the different server names dynamically using configuration file. Can anybody help me on this issue??????
December 24, 2008 at 5:33 am
Once you have found the "Package Configuration" menu item, it is pretty much a wizard. I recommend you look at the topics in books online and post back here if you have a more specific question.
December 24, 2008 at 5:43 am
Hi
You can read about it in http://www.mssqltips.com/tip.asp?tip=1405. I just googled it as "SSIS configuration". If it's just connections or simple variables you can also doit other way: U can set the variables in the dtexec parameters. Read about it at http://msdn.microsoft.com/en-us/library/ms162810.aspx. It has several parameters including one to change connections strings and variables contents. I advise you to use this last method if it's about changing few variables like 3 or 4. The configuration file is advisable if there are many variables to change.
Hope it helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply