DTS from VB code (SQL Server 7)

[cyberbiker]

I do not quite understand what I am reading between BOL and searching the forums.

I need to export certain data into a comma delimited text file.

I have created a DTS package using enterprise manager and it works pefectly from enterprise manager.

I need to run the package from VB code.

At this point, I can only think to use the shell function and run dtsrun.exe.

But this app may use a different database when in production (Such as MySQL) and I am not certain if DTS is the way to go or if there is a better way than dtsrun.exe.

Ideally, I would have my code execute a stored procedure which would then execute the DTS package in MSSQL, but I have not found a way to do that.

Any ideas would be appreciated



Terry (cyberbiker)

 

[JohnDTampaBay]

Check out

http://www.sqldts.com

for code snippets for executing a DTS package from VB and from T-SQL.

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[cyberbiker]

Thank you very much.
There looks like quite a bit of information there that will be of use for this and other projects.

Terry (cyberbiker)