Prevent sql job failure.

  • hi

  • What kind of help do you need?

    Greg

  • how to prevent this?...they told me the tables should be drop at anytime.

  • You could add a check to see if each table exists before attempting to import it. I could either be a step in the job before the step that runs the DTS package or it could be an Execute SQL task in the package itself.

    Something like:

    if exists (select * from dbo.sysobjects where id = object_id(N'tablename) and objectproperty(id, N'IsTable') = 1)

    go to the step that imports the table

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

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