Post reply

DataTransfer

  • March 18, 2013 at 3:35 am

    #150280

    Hi All,

    I have 13 databases say portfolio databases named (a, b, c, d,....m)

    I need to transfer few tables(17 tables) from each portfolio in to one single db say 'Test' .

    Currently I took 13 portfolio names in to a cursor and passing them to 17 insert statements.

    Is there any better way of doing this using ssis?

    I also want to log the errors relevant to the inserts if any.

    Any help is really appreciated.

    Thanks

  • March 18, 2013 at 6:06 am

    #1598020

    you can use SSIS to migrate your data from 1 db to another. You can create a DB with that tables you need, then create an SSIS package and point to the databases and tables you need and map those to your new database.

    I have several SSIS packages that do something similiar. Go from oracle, access, etc. and I import the data into 1 SQL database

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

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