I have x(Source) table in one server and Y(Destination) table in different server and i have a(destination),b(destination),c(destination) tables in different servers.
but x,a,b,c,y are of same structure...
1. Based on city COLUMN i have to move x data to a,b,c and y destination table at a time with out using multiple OLEDB destination transformation.
That is dynamically passing data to different destination with out oledb destination
Can you please help me on this i am new to ssis ...