Hi,
i want execute in my DTS a function .NET that has been define in a dll file !

Thanks
Mick

817248 - HOW TO: Call Visual Basic .NET Assembly from Visual Basic 6.0 and
Call Visual Basic COM Component from Visual Basic .NET
(http://support.microsoft.com/default...8&Product=vbNE
T)


You will need to expose your assembly to COM, see the section "Expose .NET
Framework Assemblies to COM Clients" in the KB link.

You can then call this via COM in an ActiveX Script Task.

An alternative would be to create a full custom task and leverage the .Net
functions that way-

328587 - HOW TO: Create a DTS Custom Task by Using Visual Basic .NET
(http://support.microsoft.com/default...7&Product=vbNE
T)


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

<sadmick (AT) hotmail (DOT) com> wrote

Hi,

I have "Expose .NET Framework Assemblies to COM Clients" (use command
Tlbexp and regasm) and now, how i call my function in activeX ?



"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

In message <d44c18b1.0405022354.1116905b (AT) posting (DOT) google.com>,
sadmick (AT) hotmail (DOT) com writes
just create the object and call the method as usual. You need to know
the progid to use in CreateObject, here is a post that explains it quite
well. Probably plenty more info in MSDN as well.

http://tinyurl.com/33nwo


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org