Post reply

how to create ssis package to copy table from one server to another server

  • December 6, 2012 at 12:20 am

    #285905

    how to create ssis package to copy table from one server to another server using BIDS

  • December 6, 2012 at 12:23 am

    #1566029

    Put a dataflow on the control flow. Add an OLE DB source and an OLE DB Destination. Done.

    (you can find stuff like this in even the most basic tutorial on SSIS. Did you do any research?)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 6, 2012 at 2:04 am

    #1566049

    Koen Verbeeck (12/6/2012)

    Put a dataflow on the control flow. Add an OLE DB source and an OLE DB Destination. Done.

    (you can find stuff like this in even the most basic tutorial on SSIS. Did you do any research?)

    But that will copy the data.I want to create new table on other server.

    Don't know if transfer sql server objects task will do it.

  • December 6, 2012 at 2:16 am

    #1566050

    You can create a new table in the OLE DB Destination component.

    Or you can use the Transfer SQL Objects task.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 6, 2012 at 3:29 am

    #1566067

    Thanks Koen.

  • October 14, 2013 at 9:26 am

    #1658291

    The transfer object task is pretty defunct. It will work the first time but anything after that if the table exists it will fail when trying to overwrite or append, even if that is the option you selected.

  • October 14, 2013 at 9:27 am

    #1658292

    Not quite that simple, you have to also put a step in between the oldb connections to select the tables you want.

Viewing 7 posts - 1 through 6 (of 6 total)

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