Would anyone know how to check for the existence of a table before starting
a transform task against it? I.e. if the table exists, go ahead and copy
it, but if not, exit the package without an error message.

thanks, -marty nicholson

IF OBJECT_ID('owner.YourTable') IS NULL
-- Get out now

--

Andrew J. Kelly
SQL Server MVP


"Martin Nicholson" <mgnicholsonNOSPAM (AT) hotmailNOSPAM (DOT) com> wrote

Thanks for the reply.

I understand the "IF OBJECT_ID" part, it's the "Get out now" part that I am
struggling with. It looks like a transformation task wants a rowset
returned, or at least a row count, or else it errors out with "invalid
pointer". What I want to do is return nothing, but have no error. In my
case, the table not existing is not considered an error.

Is there some way thru SQL that I can return a DTS code such as
DTSTransformStat_OK, or can it only be done in an activeX script?

thanks again. -marty nicholson

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

See if this gives you any ideas:

http://www.sqldts.com/default.aspx?214

--

Andrew J. Kelly
SQL Server MVP


"Martin Nicholson" <mgnicholsonNOSPAM (AT) hotmailNOSPAM (DOT) com> wrote