>can anybody help me with this....???
>
>i have a dts package saved in my local drive and i want to to be run by a simple application in vb6... help..help.. also i have script (query analyzer) that i want to run automatically using vb6... i just want these dts packages & sql scripts ran in a vb6 application.. by the im using sql7 not sql2000
For the DTS package, you can execute it through the DTSRUN utility or by creating a job that runs the package and calling the sp_start_job system procedure.
For the sql script you can save the T-SQL commands on a stored procedure of your database and call it with ADO. Something like:
oConnection.Execute "sp_start_job 'mydtsjob'" 'run job with dts package
oConnection.Execute "mystoredproc" 'run stored procedure
HTH