dbTalk Databases Forums  

Re: Call VB.NET app from DTS?

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


Discuss Re: Call VB.NET app from DTS? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Yunus's Group
 
Posts: n/a

Default Re: Call VB.NET app from DTS? - 04-14-2005 , 09:20 AM






Could you give more insight on what exactly you are trying to do? Are
you trying to just call VB.NET DLL or EXE? What is the purpose of this
application?

Check the following link, you may find the answer there.
http://docs.rinet.ru/VB/ch19.htm


Reply With Quote
  #2  
Old   
shumaker@cs.fsu.edu
 
Posts: n/a

Default Re: Call VB.NET app from DTS? - 04-14-2005 , 12:15 PM






If the VB.NET app is compiled into an *.exe then you can use a Process
Execution Task in the DTS package to run the VB.NET application. You
can even specify command line arguments to pass to the executable and
you will also havce access to the exit code that the process returns
when it exits.

If it is a DLL though, I'm not sure how you'd access the function
because I don't know if the VB used in DTS packages is capable of
loading a .NET DLL.


Reply With Quote
  #3  
Old   
dj
 
Posts: n/a

Default Re: Call VB.NET app from DTS? - 04-14-2005 , 03:23 PM



That sounds very encouraging and it makes sense about the DLL.
Have you tried using a .NET EXE from DTS?

Thanks,
dj

"shumaker (AT) cs (DOT) fsu.edu" wrote:

Quote:
If the VB.NET app is compiled into an *.exe then you can use a Process
Execution Task in the DTS package to run the VB.NET application. You
can even specify command line arguments to pass to the executable and
you will also havce access to the exit code that the process returns
when it exits.

If it is a DLL though, I'm not sure how you'd access the function
because I don't know if the VB used in DTS packages is capable of
loading a .NET DLL.



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.