Results 1 to 15 of 15

Thread: DTS package created on SQL 2K client will not run as a job on sql 7 server

  1. 09-08-2003, 10:53 AM #1
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123

    DTS package created on SQL 2K client will not run as a job on sql 7 server

    I have a DTS package created on a SQL 2K client. It is a simple export of data. It runs fine when run as a DTS package but fails when run as a job. There are no permissions issues as when I create that same package on a SQL 7 client it runs fine as a job.
    Has anybody else had the same problem ?

    Thanks!
    Reply With Quote Reply With Quote
  2. 09-08-2003, 11:05 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    See what accout you are using for SQL Agent. That account should have right access.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 09-08-2003, 11:06 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    What error message you are getting?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 09-08-2003, 11:15 AM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It could be server server agent account or your account issue or directory structure issue.

    When you run export to a file from DTS it is using directory structure in your machine, the server where you are running the job may not have the directory you are trying to write to.
    Reply With Quote Reply With Quote
  5. 09-08-2003, 11:16 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Seems mdac version mismatch between client pc and sql server.
    Reply With Quote Reply With Quote
  6. 09-08-2003, 02:00 PM #6
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    I am checking the MDAC version... thanks!
    Reply With Quote Reply With Quote
  7. 09-09-2003, 02:37 PM #7
    jas81864
    jas81864 is offline Registered User
    Join Date
    Sep 2002
    Posts
    16

    2000 dts on 7.0 server

    SQL 2000 saves the code with a different 'syntax' that SQL 7.0 will not understand. This same issue will happen with different 7.0 service pack versions. You will need to either run the package from a 2000 server or rewrite it on a 7.0 box with the same sp as the prod server.
    Reply With Quote Reply With Quote
  8. 09-09-2003, 03:48 PM #8
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123

    Re: 2000 dts on 7.0 server

    Originally posted by jas81864
    SQL 2000 saves the code with a different 'syntax' that SQL 7.0 will not understand. This same issue will happen with different 7.0 service pack versions. You will need to either run the package from a 2000 server or rewrite it on a 7.0 box with the same sp as the prod server.
    is this documented anywhere?

    Thanks
    Reply With Quote Reply With Quote
  9. 09-09-2003, 04:01 PM #9
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can check TechNet.
    Reply With Quote Reply With Quote
  10. 09-10-2003, 08:32 AM #10
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    http://support.microsoft.com/default...b;en-us;280807

    is this the article you were referring to?

    i am using sql 7 with sp3 but but i dont see any check box in my save as screen...
    Reply With Quote Reply With Quote
  11. 09-10-2003, 09:18 AM #11
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should create package in sql7 server or via sql7 client.
    Reply With Quote Reply With Quote
  12. 09-10-2003, 01:33 PM #12
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    Originally posted by rmiao
    Seems mdac version mismatch between client pc and sql server.
    yes, the MDAC version was different !

    Thanks!
    Reply With Quote Reply With Quote
  13. 09-10-2003, 01:38 PM #13
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    Originally posted by rmiao
    You should create package in sql7 server or via sql7 client.
    just a general question. if my server is on sql 7 , do i always have to create all dts packages & jobs using the sql 7 client tools?
    Last edited by Ads; 09-10-2003 at 01:41 PM.
    Reply With Quote Reply With Quote
  14. 09-10-2003, 02:01 PM #14
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Better to.
    Reply With Quote Reply With Quote
  15. 09-10-2003, 04:11 PM #15
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    ok thanks for all the help!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules