how to use Select into statement in SSIS ...that is copy data from one server to another server by creating table on the fly

Question

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

---

ilikemicrosoft

Answer 1

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/

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

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

---

(Twitter | Blog)