May 21, 2008 at 12:34 pm
hi
May 21, 2008 at 1:04 pm
What kind of help do you need?
Greg
May 21, 2008 at 2:21 pm
how to prevent this?...they told me the tables should be drop at anytime.
May 21, 2008 at 2:38 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply