I had exported MS SQL Server DTS to Visual Basic File (.bas).

I wonder how could execute dts.bas via vb.net ?

Please advise.

Many thanks.

Hello Sam,

Why are you holding the package in a .bas file and executing? Essentially
whenever you execute that .bas file you are building the package from scratch
again each time you run. Why not store the package as a structured storage
file? Much easier and no recompilation required.

Have a look here for ideas on how to execute the package.

http://www.sqldev.net/dts/DotNETCookBook.htm


Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)


Allan