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 *