• 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.

    Nothing simple, I'm afraid.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.