 | |
Re: Calling C# DLL from DTS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Calling C# DLL from DTS -
09-01-2004
, 03:21 PM
|
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 |
#2
| |||
| |||
|
|
this might help http://www.sqldev.net/dts/DotNETCookBook.htm "Andy C" <AndyC (AT) discussions (DOT) microsoft.com> wrote in message news:5F2FDBD8-8C2A-418E-84DA-721D2FFB9A7D (AT) microsoft (DOT) 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 (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#3
| |||
| |||
|
|
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/de.../en-us/cpguide /html/cpconcomcallablewrapper.asp) You can do this in VS.Net or manually- Creating a Wrapper Manually (http://msdn.microsoft.com/library/de.../en-us/cpguide /html/cpconcreatingwrappermanually.asp) In message <#016MFGkEHA.1356 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Andy Ball andy.ball (AT) remove4spam_greenfell (DOT) com> writes this might help http://www.sqldev.net/dts/DotNETCookBook.htm "Andy C" <AndyC (AT) discussions (DOT) microsoft.com> wrote in message news:5F2FDBD8-8C2A-418E-84DA-721D2FFB9A7D (AT) microsoft (DOT) 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 (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
#4
| |||
| |||
|
|
I'll get me coat ... "Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in message news:6TeZ43Z7HjNBFwAP (AT) sqldts (DOT) com... 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/de.../en-us/cpguide /html/cpconcomcallablewrapper.asp) You can do this in VS.Net or manually- Creating a Wrapper Manually (http://msdn.microsoft.com/library/de.../en-us/cpguide /html/cpconcreatingwrappermanually.asp) In message <#016MFGkEHA.1356 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Andy Ball andy.ball (AT) remove4spam_greenfell (DOT) com> writes this might help http://www.sqldev.net/dts/DotNETCookBook.htm "Andy C" <AndyC (AT) discussions (DOT) microsoft.com> wrote in message news:5F2FDBD8-8C2A-418E-84DA-721D2FFB9A7D (AT) microsoft (DOT) 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 (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.