Hi Brian,

Thanks for the great website.

I have a Vb program which needs to call a DTS to load some data into SQL server from a text file. I managed to...

Hi crosspatch,

Yes! I got it. Thank you very much.

Tina

Hi crosspath,

Thanks for the answer. here is my code:

------------------------------

Set objPackage = New DTS.Package

Set mobjPkgEvents = objPackage

objPackage.FailOnError = True

Set objStep = objPackage.Steps.New

Set objTask = objPackage.Tasks.New("DTSExecutePackageTask")

Set objExecpkg = objTask.CustomTask

objPackage.LoadFromSQLServer "SQL2000servername", "userid", "password",...