athi_ssn (2/12/2013)
I have created a sample package for the first 5 scripts having 5 different sources,dataflow task and destination. I wanted to know if there is any other simple way of implementing it other than having 30 sources and destinations. I would try out the foreach loop technique as suggesting in the first reply.Thank you for all your suggestions and help.
Sorry, no easy way. That's why I asked about the shape of the resultsets. If some were the same then you could have used a loop for those but an OLE DB Destination can only handle one type of resultset.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato