copying ofmultiple tables using Data Flow Task

• rajyagnik

  SSC Enthusiast

  Points: 143

  More actions

  June 27, 2008 at 7:18 am

  #122295

  Hi Guys,

  Does anyone know copying of multiple tables using Data Flow Task? Data Flow Task Designer does not all allow us to select multiple tables.Is there any other way?

  Thanks

  Raj

• VRT

  SSCertifiable

  Points: 5776

  More actions

  June 27, 2008 at 7:55 am

  #835353

  Raj,

  You mean that from 3 different soruce tables to three different destination tables?

  I have done same kind of package before.

  You can do this by Dataflow task.

  Create 3 data source tasks and 3 destination tasks in same Data flow task and then connect them. They will execute in parellel.

  If 3 different tables to single table then you can create a query and do that. But for this you should have one common column in all the 3 tables.

  Thank You