September 10, 2008 at 5:13 pm
Greetings, I am new to SSIS. I have to transform 20 tables from my data source to a new data destination. I wonder if there is a way to do that without creating a data source and destination for each table. Thank you,
September 10, 2008 at 5:20 pm
Yes - Import - export wizard is easiest one. Database- right click select tasks - export data..follow the wizard...sometimes you may have edit the mapping (delete the rows in destination or append, insert identity etc...)
VG
September 10, 2008 at 5:24 pm
Thanks, but I am looking to make it dynamic. I already created an SSIS that does the transformation, but I had to created 20 data flow tasks for each table. Is there an efficient way of doing it?
September 10, 2008 at 5:35 pm
There is Transfer database objects tasks...in SSIS
VG
September 10, 2008 at 5:50 pm
The Transfer Database Task would move or copy the entire database files from source to destination. I found the Transfer SQL Server Objects task to be more convenient. We can designate what table, stored proc, etc... to move. It's very cool.
September 11, 2008 at 10:06 am
Sorry, I mean to say also Transfer SQl server objects...anyway, Looks like you found a solution ..
VG
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply