"Steve Lloyd" <RemoveSteveThis@laxeyRemovepartners.com> wrote in message
news:%23BKB46BlEHA.1652@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I have an ActiveX transformation in a DTS package that runs fine if i
> execute the the individual data pump task, but behave differently if i run
> the whole package. Either from the DTS editor or from a schedule agent
> task.
>
> I have even tried the most basic script and the same thing happens. All
of
> the destination rows are <NULL>
>
> Function Main()
>
> DTSDestination("NavMktUnd") = DTSSource("NavMktUnd")
> Main = DTSTransformStat_OK
>
> End Function
>
> Has anyone seen this or have any pointers.
>
> Thanks
>
> Steve.
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:O$0pFMElEHA.644@tk2msftngp13.phx.gbl...
> Never seen this I have to say.
>
> What version and SP of SQL Server?
>
> Any chance we could look at the structure and package? We could then try
> to
> repro.
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Steve Lloyd" <RemoveSteveThis@laxeyRemovepartners.com> wrote in message
> news:%23BKB46BlEHA.1652@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> I have an ActiveX transformation in a DTS package that runs fine if i
>> execute the the individual data pump task, but behave differently if i
>> run
>> the whole package. Either from the DTS editor or from a schedule agent
>> task.
>>
>> I have even tried the most basic script and the same thing happens. All
> of
>> the destination rows are <NULL>
>>
>> Function Main()
>>
>> DTSDestination("NavMktUnd") = DTSSource("NavMktUnd")
>> Main = DTSTransformStat_OK
>>
>> End Function
>>
>> Has anyone seen this or have any pointers.
>>
>> Thanks
>>
>> Steve.
>>
>>
>
>