Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Calling C# DLL from DTS

1 view
Skip to first unread message

Andy Ball

unread,
Sep 1, 2004, 4:21:46 PM9/1/04
to
this might help

http://www.sqldev.net/dts/DotNETCookBook.htm


"Andy C" <An...@discussions.microsoft.com> wrote in message
news:5F2FDBD8-8C2A-418E...@microsoft.com...
> Hi,
>
> I have a function in a C# DLL that I want to call from an ActiveX script
> task. What do I need to do to make the DLL visible to DTS? I assume it's
got
> something to do with wrapping it up as COM - but if someone has a
definitive
> answer, that'd be great.
>
> Thanks,
>
> Andy C


Darren Green

unread,
Sep 1, 2004, 4:32:59 PM9/1/04
to
Gert talks about RCWs, the reverse of what you need which is an CCW, to
expose an assembly through COM.

You need to create a COM Callable Wrapper (CCW).

COM Callable Wrapper
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide
/html/cpconcomcallablewrapper.asp)

You can do this in VS.Net or manually-

Creating a Wrapper Manually
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide
/html/cpconcreatingwrappermanually.asp)

In message <#016MFGk...@TK2MSFTNGP09.phx.gbl>, Andy Ball
<andy.ball@remove4spam_greenfell.com> writes

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

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

Andy Ball

unread,
Sep 2, 2004, 2:09:48 AM9/2/04
to
I'll get me coat ...

"Darren Green" <darren...@reply-to-newsgroup-sqldts.com> wrote in message
news:6TeZ43Z7...@sqldts.com...

Allan Mitchell

unread,
Sep 2, 2004, 3:24:53 PM9/2/04
to
grin

Taxi for one !

--
--

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


"Andy Ball" <andy.ball@remove4spam_greenfell.com> wrote in message
news:%23AR8EbR...@TK2MSFTNGP12.phx.gbl...

Darren Green

unread,
Sep 2, 2004, 3:48:43 PM9/2/04
to
In message <OAEO3JSk...@TK2MSFTNGP09.phx.gbl>, Allan Mitchell
<al...@no-spam.sqldts.com> writes

>grin
>
>Taxi for one !
>
>--

Make sure he pays the bill before he leaves!

Andy Ball

unread,
Sep 2, 2004, 4:32:15 PM9/2/04
to
:-) gimme a break guys , been in Aus a while , so bound to get things upside
down for a while ...
AB

"Darren Green" <darren...@reply-to-newsgroup-sqldts.com> wrote in message
news:jGGP9deb...@sqldts.com...
0 new messages