Viewing 2 posts - 1 through 2 (of 2 total)
The Stored Procedure below is what I used to run a DTS package.
--------------------------------------------
IF OBJECT_ID('dbo.up_RUN_DTSPACKAGE') IS NOT NULL
BEGIN
DROP PROCEDURE dbo.up_RUN_DTSPACKAGE
IF OBJECT_ID('dbo.up_RUN_DTSPACKAGE') IS NOT...
August 18, 2003 at 6:59 am
#470258
This is what I do to set it:
exec @errorcode=sp_OASetProperty @pkgID, 'GlobalVariables ("gvImportJobID").Value', 'xxxxxxxx'
--Obtains OLE Automation error information
exec sp_OAGetErrorInfo @pkgID,
...
August 18, 2003 at 6:53 am
#470255