InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 05:20:16 GMT20http://www.sqlservercentral.com/Forums/Topic1393345-148-1.aspxThanks Koen.Thu, 06 Dec 2012 03:29:32 GMTrhythm.varshneyhttp://www.sqlservercentral.com/Forums/Topic1393345-148-1.aspxYou can create a new table in the OLE DB Destination component.Or you can use the Transfer SQL Objects task.Thu, 06 Dec 2012 02:16:58 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1393345-148-1.aspx[quote][b]Koen Verbeeck (12/6/2012)[/b][hr]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?)[/quote]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.Thu, 06 Dec 2012 02:04:42 GMTrhythm.varshneyhttp://www.sqlservercentral.com/Forums/Topic1393345-148-1.aspxPut 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?)Thu, 06 Dec 2012 00:23:47 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1393345-148-1.aspxhow to create ssis package to copy table from one server to another server using BIDSThu, 06 Dec 2012 00:20:08 GMTrhythm.varshney