Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Need help to distribute data to many different srv

Author  Topic 

NguyenL71
Posting Yak Master

228 Posts

Posted - 2013-09-24 : 13:11:57
[code]Hi,


I am fairly new to SSIS 2012, I need to fix one of the existing package. I imported the files into Staging DB
and need to be able to distribute that to 5 other servers like Server1,....Server5. Is there a wayt to do this instead creating five connections in the package. Example like read from the files to be able to change the Server name and Database Name because it's constantly changing to different servers. Any suggestions would greatly appreciate or any website info that I can look into to. This is sort of urgent and thank you very much in advance for your help. SQL 2012.

note: This must be done in the Package.

Thank you.[/code]

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-24 : 15:21:16
You can use dynamic connection string with a foreach loop container. See an example here: http://sql-developers.blogspot.com/2010/07/dynamic-database-connection-using-ssis.html
Go to Top of Page

NguyenL71
Posting Yak Master

228 Posts

Posted - 2013-09-24 : 16:57:27
[code]Thank you James, will test it out.
Again, thank you for the linked.[/code]

quote:
Originally posted by James K

You can use dynamic connection string with a foreach loop container. See an example here: http://sql-developers.blogspot.com/2010/07/dynamic-database-connection-using-ssis.html

Go to Top of Page
   

- Advertisement -