February 10, 2013 at 6:14 am
Hi friends,
This is my first post in SSC, Im new to SSIS .,
Scenario : SOURCE SQL DB NAME 'A'
DESTINATION SQL DB NAME 'B'
I want to move some tables from DB 'A' to DB 'B'
I have tried with the attached method .. Is it right?
Please suggest.
Thanks in advance
Sundar
February 10, 2013 at 6:17 am
manikam_sundar (2/10/2013)
Hi friends,This is my first post in SSC, Im new to SSIS .,
Scenario : SOURCE SQL DB NAME 'A'
DESTINATION SQL DB NAME 'B'
I want to move some tables from DB 'A' to DB 'B'
I have tried with the attached method .. Is it right?
Please suggest.
Thanks in advance
Sundar
Please define more precisely what you mean by 'move tables'. Do you mean copy data, or actually perform some DDL, or a combination?
February 10, 2013 at 6:21 am
Hi Phil,
I need to COPY data from source table to destination.
Thanks & Regards,
Sundar
February 10, 2013 at 7:18 am
A simple source-target dataflow will do the job - but you'll only be able to run it once. If you want to be able to run it multiple times, you need additional logic to handle updates somehow.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy