Hi
I am having a DTS package involving following scenario

Data is to be imported in two SQL Server tables from input text files. There is one text file each for each table. These tasks are named as DDQ1 and DDQ2 respectively. The workflow is such that on completion of DDQ1, DDQ2 should get executed

DDQ1 -------------------------------(On Completion)-------------------------> DDQ

Now, in certain case, I want to skip DDQ1 and at the same time, want to execute DDQ2 without raising any error in package

I tried follwing approaches
1) Used 'DTSStepScriptResult_DontExecuteTask' in activex script in workflow property of DDQ1. However, in this case, DDQ1 and DDQ2 are not executed
2) Used 'DTSTransformStat_Error' in pre source data transform function in DDQ1. In this case, DDQ1 is skipped and DDQ2 is executed but status of DDQ1 becomes failed as error is raised.

My question is
How to skip an execution of a data driven query task such that the next data driven query task is executed without any problem and no task in package has failed status

Thanks
Aji

Have you seen this

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ajit" <anonymous (AT) discussions (DOT) microsoft.com> wrote

and DDQ2 respectively. The workflow is such that on completion of DDQ1, DDQ2
should get executed.
executed.
becomes failed as error is raised.
package has failed status?