Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to create ssis package to copy table from one server to another server Expand / Collapse
Author
Message
Posted Thursday, December 6, 2012 12:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
how to create ssis package to copy table from one server to another server using BIDS
Post #1393345
Posted Thursday, December 6, 2012 12:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
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?)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1393348
Posted Thursday, December 6, 2012 2:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
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.
Post #1393375
Posted Thursday, December 6, 2012 2:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
You can create a new table in the OLE DB Destination component.
Or you can use the Transfer SQL Objects task.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1393379
Posted Thursday, December 6, 2012 3:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
Thanks Koen.
Post #1393404
Posted Monday, October 14, 2013 9:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:40 AM
Points: 76, Visits: 353
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.
Post #1504468
Posted Monday, October 14, 2013 9:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:40 AM
Points: 76, Visits: 353
Not quite that simple, you have to also put a step in between the oldb connections to select the tables you want.
Post #1504469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse