Hi All,

I'm having a bit of a problem with a DTS package that is accessing our AS400
for data. The only time is appears to fail is when I schedule the job. I
can run the job within the DTS designer and when I execute it from "Local
Packages" folder, but when I schedule and run the job, it fails and I get
this error message:

Executed as user: SPSHR\SYSTEM. ...
OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
Error Detail Records: Error: 5 (5); Provider Error: 5 (5)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
.... Process Exit Code 2. The step failed.

I think the problem might be the user which is running the DTS package
(SPSHR/SYSTEM). I think I need to set up my user account from the AS/400 to
access the text file, but I'm not sure where this is to be done.

Does anyone have any ideas on how to fix this issue?

Thanks!

Brian.

Hello Brian,

You are right. The 80004005 is telling us that there is a permissions issue
or that the details are incorrect. This problem because you are OK when
manually running the package and are not when scheduling can usually be sorted
by reading this article

http://support.microsoft.com/?kbid=269074


Allan

Thanks, Allan,

I read the article, but I don't think it helps my situation. Because this
account I am accessing is not in my Windows AD (it's on the AS/400), I need
a way to enter the AS/400 username/password credentials.

Is there a way to assign the username/password in the DTS package designer?
I am simply transforming a flat file from a shared directory on the AS/400
to the MSSQL table. AS/400 is a little more stringent in it's security as
it will not allow you to simply hit the share without a username/password.

Thanks,

Brian.

Thanks,

Brian.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Brian,

Would the username and password be that needed by the share on the AS400?
If it is then how do you do this interactively? Can you not use NET USE?
Can you use FTP? If you can wither of these two things then you should
be able ti build up the requirements in a package.


Thanks

Allan

Hi I am getting the following messages after the patch, Need help asap please.

"Executed as user: 123start\Admini. ...ing... DTSRun OnStart: Delete from
Table [MMLive].[dbo].[temp_stock] Step DTSRun OnFinish: Delete from Table
[MMLive].[dbo].[temp_stock] Step DTSRun OnStart: Copy Data from MMLINV to
[MMLive].[dbo].[temp_stock] Step DTSRun OnError: Copy Data from MMLINV to
[MMLive].[dbo].[temp_stock] Step, Error = -2147467259 (80004005) Error
string: Error opening datafile: The system cannot find the path specified.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 Error
Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string:
Error opening datafile: The system cannot find the path specified.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 DTSRun
OnFinish: Copy Data from MMLINV to [MMLive].[dbo].[temp_stock] Step
DTSRun: Package exec. The step failed.

Many thanks,

Steve

"Allan Mitchell" wrote: