Home Forums SQL Server 2005 SQL Server 2005 Integration Services how to create ssis package to copy table from one server to another server RE: how to create ssis package to copy table from one server to another server

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