by All,
I have a DTS package that is designed to access a web page
via a VB Script task, and place the resulting XML document
into a global package variable. Then this global variable
is passed into the f9ollowing stored procedure via an
Execute SQL Task (Call: EXEC bsp_PopulateTempXML ?) :
CREATE PROCEDURE bsp_PopulateTempXML
AS
DECLARE
BEGIN
SELECT DISTINCT *
INTO #TempTab
WITH
(TYPE CHAR(1),
[DATE] DateTime,
[TIME] DateTime,
MOBILE VARCHAR(20),
MOBILE_NAME VARCHAR (20),
LOCATION VARCHAR (20))
INSERT INTO RAPIDS_XML_Import
(EVENTTYPE,EVENTDATETIME,MOBILE,MOBILE_NAME,LOCATION,
STATUS)
(SELECT TYPE,DATE + ' ' + TIME AS
EVENTDATETIME,MOBILE,MOBILE_NAME,LOCATION, 'X' FROM
#TempTab)
END
END
GO
The last step of the package is a VB Script task which
processes this data now available in the import table into
the main system.
All of this runs just fine when executed interactively,
either step by step or as a package whole. I can (and
did) have this same package/job scheduled and running on a
development platform. The only difference between these
two platforms is that production runs on a Win2K Server
and our dev platform is still on NT 4.0 (SP6).
I have already run through KBID 269074 (How to run a DTS
Package as a Scheduled Job) with no relief, and we run
MANY DTS packages here, which means we are fairly well
versed at this. This job is an exception and it is
driving me nuts!
FWIW, the actual error message found within the Job
History is this:
Executed as user: RAP05\RAP05SQLSvc. ...ting... DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421
(8004043B) Error string: The task reported failure
on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail
Records: Error: -2147220421 (8004043B); Provider
Error: 0 (0) Error string: The task reported
failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error: -
2147467259 (80004005); Provider Error: 0 (0) Error
string: The system cannot locate the resource
specified. Error source: msxml3.dll Help
file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_1, Error = . The step failed.
Can anyone set me straight here?
Sorry for the long post,
Steve