Home Forums SQL Server 2005 SQL Server 2005 Integration Services how to create ssis package to copy table from one server to another server RE: how to create ssis package to copy table from one server to another server
lmacdonald
Hall of Fame
Points: 3763
More actions
October 14, 2013 at 9:26 am
#1658291
The transfer object task is pretty defunct. It will work the first time but anything after that if the table exists it will fail when trying to overwrite or append, even if that is the option you selected.