how to use Select into statement in SSIS ...that is copy data from one server to another server by creating table on the fly
I have a server A which has some tables....
i want to copy all the data from the server A table to Servcer B which does not have any of the table created...(ie the tables are not physially present)
How can i do the..something like this
SELECT * INTO SERVER B Table from SERVER A Table
how can i do the above in SSIS
SSIS you can create two SQL Tasks - one for creating table (with T_SQL script) on ServerB and following task populating table
also pls check this similar thread http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/272ddd31-1812-422c-aad7-8671a4c7e0b2/
2012年3月7日 11:17In SSIS, you would need to explicitly create the tables first. You might want to look at the "Import/Export Data Wizard", which creates a two-step package, the first to create the table and the second to copy the data.