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.