Chris Davoli wrote:
Quote:
Environment is SQL Server 2000.
I know how to write VB script code in a DTS pakage (using the drag drop of
the Active X Script), but can I use VB.Net code instead?
Also, is there any examples of how to do this ie; how to add references,
some code examples? |
You cannot use VB.Net code directly in the task. You could however write
an assembly in VB.Net, compile it, create a COM callable warpper (CCW),
register it to be visible by COM, and then call that object, it's
methods etc, from VBScript in the task.
COM Callable Wrapper
(http://msdn.microsoft.com/library/de...blewrapper.asp)
Creating a Wrapper Manually
(http://msdn.microsoft.com/library/de...ermanually.asp)
How to call a Visual Basic .NET assembly from Visual Basic 6.0 and how to
call a call Visual Basic COM component from Visual Basic .NET
(http://support.microsoft.com/default...en-us;817248#6)
--
Darren
http://www.sqldts.com
http://www.sqlis.com