Post reply

SQL Server Agent job

  • May 27, 2008 at 9:12 am

    #123994

    Hi,

    I have a SQL Server Agent job set up to run a job that calls a dts package on the server.

    When I run the DTS Package manually, everything works fine and does what it is supposed to do.

    When I run the job, The job fails. If somebody had this error can you please help me out

    I am getting following error in my job...

    DTSRun: Loading...Error: -2147287038 (80030002);

    Provider Error: 0 (0)

    Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts.hlp

    Help context: 713.

    Process Exit Code 1. The step failed.

    could you please let me know what is the possible cause for the above error.

    Many Thanks,

    Madhu

  • May 27, 2008 at 9:45 am

    #820633

    madhusudhana.r (5/27/2008)

    Error string: The system cannot find the file specified. Error source:

    Obviously, the specified file is not on the server. Check the location, based on your DTS package, and see if the file it expects actually resides in that folder.

    -- You can't be late until you show up.

  • May 27, 2008 at 9:51 am

    #820642

    Hi tosscrosby,

    Thanks for your Reply. The DTS package is getting the data from BW. when we run the DTS manually it is running successfully without giving any error.

    When we configured it as a job it is failing. We are not using or retrieving any files from the server.

    Regards

    Madhu

  • May 27, 2008 at 9:52 am

    #820644

    I haven't seen this error before. What version of SQL Server are you using? I found this on KnowledgeBase and it refers to using SQL 7.0: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274716

    Greg

  • May 27, 2008 at 10:14 am

    #820658

    Hi Greg,

    This is the only one production server having the old sqlserver version. Following are the version details:-

    SQLSERVER 7.0 with Service Pack2

    Many Thanks,

    Madhu

  • May 27, 2008 at 10:16 am

    #820660

    Sorry, missed the part about it running fine manually:blush:

    Here is another link. Also, when I google the error, a lot of the hits point to the SQL7-SQL2K issue the Greg stated/posted the link for.

    http://www.tek-tips.com/viewthread.cfm?qid=1249475&page=1

    -- You can't be late until you show up.

  • May 27, 2008 at 10:44 am

    #820679

    Thanks Greg. We have fixed the issue based on the link provided by you.

    Many Thanks,

    Madhu

  • May 27, 2008 at 10:58 am

    #820692

    Great! Glad to help.

    Greg

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply