January 26, 2011 at 3:00 am
I have one database source server and two destination server so i used multicast and data is flowing good from source to these parallel destination.
now i want something different that if tomorrow i want to add one or more server to destination then path then how can i work it out without my dependency. i want this to be done like an automated process.
If any new destination comes then should be added automatically to my data flow or the root of multicast from where i am passing my data to destination servers.
January 29, 2011 at 6:09 am
scottichrosaviakosmos (1/26/2011)
I have one database source server and two destination server so i used multicast and data is flowing good from source to these parallel destination.now i want something different that if tomorrow i want to add one or more server to destination then path then how can i work it out without my dependency. i want this to be done like an automated process.
If any new destination comes then should be added automatically to my data flow or the root of multicast from where i am passing my data to destination servers.
You should look into programmatically controlling your SSIS packages through the .NET API.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply