-
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!
-
See what accout you are using for SQL Agent. That account should have right access.
-
What error message you are getting?
-
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.
-
Seems mdac version mismatch between client pc and sql server.
-
I am checking the MDAC version... thanks!
-
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.
-
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
-
-
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...
-
You should create package in sql7 server or via sql7 client.
-
Originally posted by rmiao
Seems mdac version mismatch between client pc and sql server.
yes, the MDAC version was different !
Thanks!
-
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.
-
-
ok thanks for all the help!
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
|
|