good for start, but if I have more complex dts...may be I can create a job and after execute it from vb.exe with

"sp_start_job @job_name = 'My Job'"

using and ADO connection and execute it.

Excellent !!!

Good job to describe in few lines

Can I use this variables as a parameter to my SQL server Query for downloading the data

Thanks again

AMIT

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 execute the DTS, but I couldn't get any return from DTS, so don't know if my data is loaded correctly unless I check from SQL server. Could you please explain how to solve this problem? Thank you very much!

Tina from Singapore

Hi Brian,

I have many long running dts packages and need a way to notify the client of how many rows have been read.  I have played with the On Progress event but my package just freezes up when I check this event. 

Another nice feature that I want to add is the ability to cancel a package once it starts. 

Any ideas.....

Thanks for your help

If your process is long time running process maybe you can send email to client when it is done. DTS package has this possibility or you can use SQL command inside DTS package to send e-mail from SQL server

Thanks

Janusz

Create your DTS package and save it as VB script, next open it in VS2003 or VS2005 and allow VS to convert it. After that you will have all you need to run package from .Net language. You will have some error to fix because the conversion is not fully valid but they are very easy to fix. You can use this created code to not only run package from your application but you can also create it from your application.

Thanks