"Guruper" <Guruper@discussions.microsoft.com> wrote in message
news:eyqv7FXfFHA.3904@TK2MSFTNGP14.phx.gbl...
> I'm just trying to get an overview of the new "DTS" of SQL Server 2005.
> I've tried to convert an old DTS 2000 package to SSIS Package. The package
> simply consist of a transformation from one file to another. The
> transformation has a Workflow ActiveX script task which says
> Main=DTSStepScriptResult_DontExecuteTask if a given package variable is
> False. If the variable is true, then Main =
> DTSStepScriptResult_ExecuteTask.
>
> After converting the package to SQL Server 2005, this functionality seems
> to be gone. The transformation is executed no matter what the value of the
> variable is.
>
> Any hints on how to execute tasks and transformations like this in SSIS?
>
> Per :-)
>
>

"Guruper" <Guruper@discussions.microsoft.com> wrote in message
news:eyqv7FXfFHA.3904@TK2MSFTNGP14.phx.gbl...
> I'm just trying to get an overview of the new "DTS" of SQL Server 2005.
> I've tried to convert an old DTS 2000 package to SSIS Package. The package
> simply consist of a transformation from one file to another. The
> transformation has a Workflow ActiveX script task which says
> Main=DTSStepScriptResult_DontExecuteTask if a given package variable is
> False. If the variable is true, then Main =
> DTSStepScriptResult_ExecuteTask.
>
> After converting the package to SQL Server 2005, this functionality seems
> to be gone. The transformation is executed no matter what the value of the
> variable is.
>
> Any hints on how to execute tasks and transformations like this in SSIS?
>
> Per :-)
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:O3Xsu1afFHA.1416@TK2MSFTNGP09.phx.gbl...
> Maybe this article will help
>
> Introduction to Expressions on Workflow
> (http://www.sqlis.com/default.aspx?306)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Guruper" <Guruper@discussions.microsoft.com> wrote in message
> news:eyqv7FXfFHA.3904@TK2MSFTNGP14.phx.gbl...
>> I'm just trying to get an overview of the new "DTS" of SQL Server 2005.
>> I've tried to convert an old DTS 2000 package to SSIS Package. The
>> package simply consist of a transformation from one file to another. The
>> transformation has a Workflow ActiveX script task which says
>> Main=DTSStepScriptResult_DontExecuteTask if a given package variable is
>> False. If the variable is true, then Main =
>> DTSStepScriptResult_ExecuteTask.
>>
>> After converting the package to SQL Server 2005, this functionality seems
>> to be gone. The transformation is executed no matter what the value of
>> the variable is.
>>
>> Any hints on how to execute tasks and transformations like this in SSIS?
>>
>> Per :-)
>>
>>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:O3Xsu1afFHA.1416@TK2MSFTNGP09.phx.gbl...
> Maybe this article will help
>
> Introduction to Expressions on Workflow
> (http://www.sqlis.com/default.aspx?306)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Guruper" <Guruper@discussions.microsoft.com> wrote in message
> news:eyqv7FXfFHA.3904@TK2MSFTNGP14.phx.gbl...
>> I'm just trying to get an overview of the new "DTS" of SQL Server 2005.
>> I've tried to convert an old DTS 2000 package to SSIS Package. The
>> package simply consist of a transformation from one file to another. The
>> transformation has a Workflow ActiveX script task which says
>> Main=DTSStepScriptResult_DontExecuteTask if a given package variable is
>> False. If the variable is true, then Main =
>> DTSStepScriptResult_ExecuteTask.
>>
>> After converting the package to SQL Server 2005, this functionality seems
>> to be gone. The transformation is executed no matter what the value of
>> the variable is.
>>
>> Any hints on how to execute tasks and transformations like this in SSIS?
>>
>> Per :-)
>>
>>
>
>