Additional to Mark's comments (see "> Executed By: ronwalk" in the log
file), if it's not a logon problem.
I have seen 'other' different problems with DTS Packages.
Your post refers to:
> Step 'DTSStep_DTSExecuteSQLTask_1' failed
and
> Error Description:Package failed because Step
'DTSStep_DTSExecuteSQLTask_3' failed.
Ex 1. Task1 of the 3-Step DTS Package can also have 'trouble' due to a
'change' of data in the database.
The SQL SELECT statements in Step 1 may be selecting data for
CompanyCode='ABC'. But 'somehow' the database has been restored from a
'test' machine backup. The 'test' data has no records for CompanyCode='ABC'
but does have 'XYZ'.
In this case Step 1 will fail to create an extract file, and Step 2 will
fail to find the file, and Step 3 will fail to 'send' the file. Therefore
the whole DTS Package fails.
Ex 2. Task 1 may be able to 'correctly' execute the SELECTion criteria, but
could also be having 'trouble' because of a Folder Name Change (the folder
where it is supposed to save the extracted file). Again, Steps 1, 2 and 3
will fail, causing a Package fail.
Hope this may help give you some 'other clues'.
Kindest Regards,
Tom Lang.
"Mark Halstead" <[log in to unmask]> wrote in message
news:tOidnbHzoJ6k5wGjXTWcpQ@fidnet.com...
> Hi Kent,
> When you run the task in session it is using your current logon, in batch
it
> uses whatever you specified as the SQL Server agent logon. I believe the
> default is for SQL Server Agent to logon as the "system account", a user
> that has few privileges and can't typically access the network. I
generally
> create a special account for SQL Server agent.
>
>
> Regards,
>
> Mark
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of KENT WALLACE
> Sent: Tuesday, April 15, 2003 2:49 PM
> To: [log in to unmask]
> Subject: [HP3000-L] OT DTS scheduler
>
>
> I can execute a Data Transformation package in session(HP talk). When I
> schedule the same package(batch) it fails. It tells me I do not have
access
> to the groupwise directory.
>
> >From the log file:
>
> The execution of the following DTS Package failed:
>
> Error Source: Microsoft Data Transformation Services (DTS) Package
> Error Description:Package failed because Step
'DTSStep_DTSExecuteSQLTask_3'
> failed.
> Error code: 80040428
> \Error Help File:sqldts80.hlp
> Error Help Context ID:700
>
>
> Package Name: JEDIERR@
> Package Description: (null)
> Package ID: {6E0BC938-C1D1-4211-B058-EBB289B88EF6}
> Package Version: {54C933A3-C479-46D0-8287-ECF19317D35C}
> Package Execution Lineage: {8FA4BAB7-68A3-412A-99CB-58B4D1762A82}
> Executed On: 120-RZ6IM19
> Executed By: ronwalk
> Execution Started: 4/15/2003 2:07:54 PM
> Execution Completed: 4/15/2003 2:09:01 PM
> Total Execution Time: 66.986 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSExecuteSQLTask_1' failed
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
