Hi,

We have an ActiveX Script as the first task in a DTS Package. It
archives a file, and copies it to the working directory on the server
for importing and enrichment of the data.

The following steps import (using the file as a Text File Connection) by
transforming the data to the SQL Server table connection, then they
enrich the data end export it to a final output file.

The final step cleans up.

Trouble is, if the file is not there we don't want an error raised, we
just want the DTS Package to stop with no errors.

How can we do this?

I've tried using a workflow with 'On Error' precedence but the Package
always fails and raises an error. I've also tried using an If..Then
block with atest for the file and setting
'Main=DTSTaskExecResult_Failure' if the file isn't there...

Any ideas?

thanks

Philip




*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Check the file in an ActiveX Script task and then enable/disable the
following task depending on the outcome

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"no spam" <anonymous (AT) devdex (DOT) com> wrote