Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DataTransfer Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 3:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 01, 2013 3:42 AM
Points: 111, Visits: 346
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
Posted Monday, March 18, 2013 6:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 11:21 AM
Points: 176, Visits: 346
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 »

Add to briefcase

Permissions Expand / Collapse