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.