How to call DTS (SQL server 2000) from Visual Basic [Archive]

View Full Version : How to call DTS (SQL server 2000) from Visual Basic

khongdunghang

01-20-03, 00:11

Dear friends,
I am implementing a COM by VisualBasic. In this COM, I want to call a DTS package on SQL server to transfer data.
How can I do that? Please help me!

playernovis

01-20-03, 00:33

check this for DTS API

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dblibc/dtspapps_21rn.asp

and this for an example

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dblibc/dtsptasks_61gp.asp
http://sqldev.net/dts/ExecutePackage.htm

jiri

khongdunghang

01-20-03, 22:06

Very thanks, playernovis!