Move Multiple tables from SQL Source to SQL Destination

• manikam_sundar

  SSC Veteran

  Points: 242

  More actions

  February 10, 2013 at 6:14 am

  #273942

  Hi friends,

  This is my first post in SSC, Im new to SSIS .,

  Scenario : SOURCE SQL DB NAME 'A'

  DESTINATION SQL DB NAME 'B'

  I want to move some tables from DB 'A' to DB 'B'

  I have tried with the attached method .. Is it right?

  Please suggest.

  Thanks in advance

  Sundar

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  February 10, 2013 at 6:17 am

  #1586294

  manikam_sundar (2/10/2013)

  ---

  Hi friends,

  This is my first post in SSC, Im new to SSIS .,

  Scenario : SOURCE SQL DB NAME 'A'

  DESTINATION SQL DB NAME 'B'

  I want to move some tables from DB 'A' to DB 'B'

  I have tried with the attached method .. Is it right?

  Please suggest.

  Thanks in advance

  Sundar

  Please define more precisely what you mean by 'move tables'. Do you mean copy data, or actually perform some DDL, or a combination?

  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.

• manikam_sundar

  SSC Veteran

  Points: 242

  More actions

  February 10, 2013 at 6:21 am

  #1586295

  Hi Phil,

  I need to COPY data from source table to destination.

  Thanks & Regards,

  Sundar

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  February 10, 2013 at 7:18 am

  #1586298

  A simple source-target dataflow will do the job - but you'll only be able to run it once. If you want to be able to run it multiple times, you need additional logic to handle updates somehow.

  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.