July 16, 2003 at 8:15 pm
Like many others i have a dts procedure that runs fine manually but on a schedule fails. I have all permissions set as admin and the servers are communicating. When this problem actually started is when I updated the MDAC to 2.7. It was running fine prior to this. I am usinf sql 7. Thank you for your time.
M
July 17, 2003 at 4:49 am
What is the error you are receiving and walk us thru your process. It could be the MDAC but less likely when a manual run is fine.
However if the manual run is done from you local machine and not the server where the scheduled run is done then you have to keep in mind that the code is executed based on the conditions of your local machine which if your MDAC is not the same could point to the issue being the one on the Server. I suggest do a manual test from the server machine itself, if fails may be more informative.
July 17, 2003 at 6:09 am
That is part of the problem, there is no error message. It just hangs on step one. Like I said earlier, it runs manually but not on schedule and there is no error message. Thanks again
M
July 29, 2003 at 9:06 am
We recently had a simular problem at my place of work. We loaded the 7.0 client onto our new XP boxes and discovered issues with running packages via the schedule. The problem is with the version of MDAC on your local machine versus the server when both are using 7.0.
To fix this, open your package while physically on the server. Change your connections and then change them back to what they were (the act of changing them is all that is needed). Save the package. You should be able to run the package locally on your box and via the schedule. You will have to do this every time you change a package using your personal machine.
We had this problem go away once we loaded the SQL2000 client on the XP box. We are able to change packages locally and they still run on the 7.0 server.
The issue appears to be having the local client with a later version of MDAC then the server when both the server and local client are SQL7.0.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply