Hi,

I have a created A DTS package using the import wizard, and I selected the
radio button so it delete's rows from the destination tbale.
I want to modify this so it only delete's rows if there are rows in the
source table (prob using an EXISTS clause)
But there is no where in the DTS designer that gives you access to the SQL
to modify the delete statment, does anyone know if there is a way to do this?

Thanks

You can open the package in the DTS designer and edit the Execute SQL Task,
which will contain the DELETE statement. However you cannot reference the
source connection in a statement running against the destination connection.
Have a look at the Data Driven Query task, and lookups, or even the DataPump
task and lookups.

Or

Load all data into a staging table and then use T-SQL to delete and insert
rows as required.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Billy" <Billy (AT) discussions (DOT) microsoft.com> wrote