Hello,
I am wondering if it is possible to include a class and to instanciate it
into a dts script?

Thanks


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

You might want to use the ActiveX Script Task in DTS.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Ernesto L via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Hello,
I am wondering if it is possible to include a class and to instanciate it
into a dts script?

Thanks


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

Thank you for your answer.
But can you give me an example?

I have a class written in ASP and I want to use It in DTS.
But I'm not sure I can unclude it and use it?


Narayana Vyas Kondreddi wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

ActiveX script task is a task in the DTS Designer. Here's some example code
from ActiveX script task: http://www.sqldts.com/default.aspx?211
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Ernesto L via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Thank you for your answer.
But can you give me an example?

I have a class written in ASP and I want to use It in DTS.
But I'm not sure I can unclude it and use it?


Narayana Vyas Kondreddi wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

The only way to use an ASP class is through ASP, and the IIS handler. There
is no ASP parser, similar to the VBScript host for example.

You could write a script component and use that from ASP and DTS, or better
still a COM DLL.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Ernesto L via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote