SSIS puzzle

  • Hey guys I thought this might interest SSIS developers here:

    Problem statement:

    I have two servers S1 and S2 and the source table is in Server1. There is no destination table in Server2.

    I want to move data from server S1 to S2 using a SQL command Select * into <Server2table> From <Server1Table> by creating the table dynamically. Linked servers are not allowed and this has to be done using SSIS.

    How would you approach this?

    Good luck 🙂

  • I tried different approaches but I think I have to create the object manually in the destination before I do the load as a last resort. Any suggestions about creating the table dynamically?

  • Create the target (perhaps using something like this) and load it. Your constraint of wanting to do a SELECT INTO but not being able to see/utilize [server2] from [server1] makes any sort of TSQL a little bit difficult.

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply