SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Need help to distribute data to many different srv
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

NguyenL71
Posting Yak Master

USA
206 Posts

Posted - 09/24/2013 :  13:11:57  Show Profile  Reply with Quote
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.

James K
Flowing Fount of Yak Knowledge

3329 Posts

Posted - 09/24/2013 :  15:21:16  Show Profile  Reply with Quote
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

USA
206 Posts

Posted - 09/24/2013 :  16:57:27  Show Profile  Reply with Quote
Thank you James, will test it out.
Again, thank you for the linked.


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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000