Post reply

Transfer SQL Server Objects Task - Am I using the correct task?

  • February 19, 2010 at 11:00 am

    #219331

    Hi,

    Im trying to use the Transfer SQL Server Objects Task to transfer tables from a staging server Database to the live database. I want to retain the data in Live database, unless changes have been made to the table data on the staging DB. Both databases reside on the same SQL Server 2005 system. Am I using the correct task to accomplish this?

    Thanks,

    Larry

  • February 19, 2010 at 11:52 am

    #1122049

    No. The Transfer SQL Server Objects Task is for moving objects + data (if table). You should use an Execute SQL Task to insert/update/delete the data in the live table.

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply