Page 1 of 2 12 LastLast
Results 1 to 15 of 24

Thread: DTS Error

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: DTS Error

    I am trying to run a scheduled package in the DTS and keep getting a the error message in the job history:
    'Executed as user: UTSQL01\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun OnError: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.'
    Is there someone that knows what this means and how I can correct it?
    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm assuming that when you run it manually it works....

    It sounds like a security issue....the sql agent account needs permission

    Yes?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    It is a security issue. I can't seem to get around it though. I log on as administrator and I get a whole new set of errors. I am now trying to export to Excel and get the error that the path to the Excel sheet is wrong. How do I give permissions?
    Thanks.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    This should answer your question:

    link

    Let me know if you still have the problem.

  5. #5
    Join Date
    Aug 2003
    Posts
    328
    I can't change the owner info in the Owner drop-down combo box which is what it tells me to do.
    Thanks for your help. The link you sent was the right one.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Are you stuck ... ?

  7. #7
    Join Date
    Aug 2003
    Posts
    328
    Very. How can I change the owner?
    Last edited by exdter; 11-12-03 at 14:23.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    What happens when you change the owner and select apply ? Do you have administrator rights ?

  9. #9
    Join Date
    Aug 2003
    Posts
    328
    The owner combobox is grayed and I can't even access it.

  10. #10
    Join Date
    Feb 2002
    Posts
    2,232
    Do you have sys admin access ? Can you login as the owner ?

  11. #11
    Join Date
    Feb 2002
    Posts
    2,232
    You can also try the stored procedure to change the ownership:
    sp_update_job

  12. #12
    Join Date
    Aug 2003
    Posts
    328
    I can't run it for some reason. I don't know much about this stuff.
    Last edited by exdter; 11-12-03 at 14:54.

  13. #13
    Join Date
    Feb 2002
    Posts
    2,232
    Try msdb.dbo.sp_update_job ... What is your access level in sql server ? Have you tried logging in as sa ?

  14. #14
    Join Date
    Aug 2003
    Posts
    328
    I can run the procedure in Query Analyzer but I get the message:
    Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24
    Supply either @job_id or @job_name to identify the job.
    Stored Procedure: msdb.dbo.sp_update_job
    Return Code = 1

    Where do I put the job_id or job_name?

    Thanks again for your help.

  15. #15
    Join Date
    Aug 2003
    Posts
    328
    The job now says it succeeded but when I open the destination file, there is no data there. I'm lost.
    And I ran the procedure msdb.dbo.sp_update_job and got a:
    Stored Procedure: msdb.dbo.sp_update_job
    Return Code = 0
    message.
    Last edited by exdter; 11-12-03 at 15:43.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •