June 25, 2012 at 9:30 am
Hi,
Can I use SSIS to copy data from a remote SQL Server table to a local SQL table?
All I need to do is join the two tables and copy data from the remote table when it's not present in the local SQL table. Unfortunately I don't have a linked Server between the two. Is it possible to use SSIS in this case? Any help is appreciated.
Thanks,
Greg
June 25, 2012 at 2:34 pm
Is this a 1 time action or is it going to be a recurring thing ? Since its not a linked server can you fully qualify the server names to get at the data ? If its a one time action and you don't see anyway to get to the data you can always export the data from the remote server into a pipe delimited file then do a import into the local server from the pipe delimited file.
I am just throwing stuff up on the wall and seeing if any sticks for you.
June 25, 2012 at 5:18 pm
Yes you can use SSIS to do this. Either use the dataflow to move the whole table then run T-SQL to merge the data into the destination table or you can build a merge process in SSIS.
June 26, 2012 at 9:52 am
Hi,
I used SSIS to copy a subset to a "staging" table on the target server then a SQL statement to insert only new records. I'm unfamiliar with the SSIS merge item, but will look at it now. Thanks for the responses!
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply