ActiveX Transformation in DTS Package

#1

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.

#2

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 (AT) laxeyRemovepartners (DOT) com> wrote

Quote:

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.

#3

Oops sorry, it was me being a muppet...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

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 (AT) laxeyRemovepartners (DOT) com> wrote in message
news:%23BKB46BlEHA.1652 (AT) TK2MSFTNGP09 (DOT) 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ActiveX Transformation in DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

ActiveX Transformation in DTS Package - 09-06-2004 , 09:37 AM

Re: ActiveX Transformation in DTS Package - 09-06-2004 , 01:55 PM

Re: ActiveX Transformation in DTS Package - 09-14-2004 , 04:23 AM