MS SQL Server DTS - Transfer SQL Server Objects Task

Author

Transfer SQL Server Objects Task - Suppress DropObjectsFirst Excep

GavinM

2006-01-21, 3:23 am

Setting this property to True causes an error to be raised if a table that is
being copied does not exist in the destination database.

In my opinion this is actually a bug since there really is no need to raise
an exception when the desired result (no table) has already been achieved.

I am trying to create a work around by adding a Script Task to the OnError
event handler for the task.

I hope to examine the error that has been raised and, if it is something
like the following, then I want to suppress the exception and continue
processing of the task.

ERROR : errorCode=-1073548784 description=Executin
g the query "DROP TABLE
[dbo].[Table1] failed with the following error: "Cannot drop the table
'dbo.Table1', because it does not exist or you do not have permission."

Is this possible? I would appreciate some tips on where to start. How do I
access the current exception and how do I cancel it?

Thank you.

Gavin M

Sponsored Links