Thank you for your reply!!!!!

Do you have any idea how many processors are required for running multiple data flow tasks in parallel,can you give me a scenario that you have...

Hi Ahok,

Thanks you so much for your reply.........

But I cant find any thing in the properties of expressions in Dataflow task.are you asking me to check in the source and...

Thank you for your reply Mukti,

Actually, my situation is my database name,server name are coming from execute SQL task and these will be changing dynamically ,according to the server name...