|
|
You're in the
sql server dts
group:Changing Access Accounts on a DTS Package
sql server dts:
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 [quoted text, click to view] > 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. >
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. [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:d4c9a65241c0b8c7e1975edfb6f8@msnews.microsoft.com... > 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 > > >> 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,
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 [quoted text, click to view] > 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@no-spam.sqldts.com> wrote in message > news:d4c9a65241c0b8c7e1975edfb6f8@msnews.microsoft.com... > >> 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 >> >>> 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. >>>
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 [quoted text, click to view] "Allan Mitchell" wrote:
> 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 > > > > 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. > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |