Post reply

Move Multiple tables from SQL Source to SQL Destination

  • 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

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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 10, 2013 at 6:21 am

    #1586295

    Hi Phil,

    I need to COPY data from source table to destination.

    Thanks & Regards,

    Sundar

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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply