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.
| 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 DBand 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 |
 |
|
|
NguyenL71
Posting Yak Master
228 Posts |
|
|
|
|
|
Need help to distribute data to many different srv