Executing DTS packages on SQL server

[owenxp]

Help!!! :eusa_wall

I created a DTS package on MS SQL server and tried using the stored procedures sp_OACreate, sp_OAMethod etc. to execute the DTS package. The process run without error, but the DTS package was not exeecuted. What could be the problem?

[SQLDBA]

Why not run the package as a job ?,why you choose to use those stored procedures

[SQLDBA]

where you executing from,EM,QA or from a VB program.Anyway avoid those store procedures,why execute the package as an OLE object ?

[owenxp]

well I want to check if records are in a particular table first. If the records are there then, I execute the DTS package and email the results. thats why i want to execute it via an SP.

[SQLDBA]

You can still do that via DTS so you need to refine your approach,will get back to you later