none
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


    ilikemicrosoft

    2012年3月7日 11:11

答案

  • 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


    2012年3月7日 11:16
  • 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)

    2012年3月7日 11:17

全部回复

  • 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


    2012年3月7日 11:16
  • 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)

    2012年3月7日 11:17