dbTalk Databases Forums  

VB.Net code in an Active X Script task in a DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss VB.Net code in an Active X Script task in a DTS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Davoli
 
Posts: n/a

Default VB.Net code in an Active X Script task in a DTS package - 12-09-2005 , 09:10 AM






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?
--
Chris Davoli


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: VB.Net code in an Active X Script task in a DTS package - 12-12-2005 , 02:05 AM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.