DataTransfer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » DataTransfer

DataTransfer

Rate Topic

Display Mode

Topic Options

Author

Message

Deepthy

Posted Monday, March 18, 2013 3:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:14 AM
Points: 111, Visits: 342

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

Post #1432120

SQL_NuB

Posted Monday, March 18, 2013 6:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 25, 2013 9:35 AM
Points: 172, Visits: 331

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

Post #1432157

« Prev Topic | Next Topic »

Permissions