View Full Version : Executing DTS packages on SQL server
February 23, 2005, 10:57 AM
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?
February 23, 2005, 11:06 AM
Why not run the package as a job ?,why you choose to use those stored procedures
February 23, 2005, 11:09 AM
where you executing from,EM,QA or from a VB program.Anyway avoid those store procedures,why execute the package as an OLE object ?
March 1, 2005, 07:32 AM
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.
March 1, 2005, 07:36 AM
You can still do that via DTS so you need to refine your approach,will get back to you later
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.