DTS

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric :

I have a SQL Server 7.0 (SP2) running on Win NT 4.0 server. The scheduled DTS Packages on the database server does not execute at all, however i can run the same job manually (i have checked if the packages were saved locally or not) I have read somewhere that DTS has some bugs...

Your feedback on this would be appreciated

Prem

-- Anonymous, July 09, 2001

Answers

Prem,

Yes, about 75 bugs. Check out this list of SQL Server 7.0 bugs concerning DTS:

http://search.microsoft.com/us/SearchMS.asp? so=RECCNT&qu=kbSQLServ700bug+dts&boolean=ALL&i=07&nq=NEW

(This must be typed all on one line without spaces.)

Hope this helps,

Eric

-- Anonymous, July 10, 2001


I had this problem with SQL Server 2000(standard) but it had nothing to do with bugs. My problem dealt with the DTS package creating an exception file to record problems. The issue here though was the user who created the DTS package did not have proper permissions set for the directory the file was to be created in. I corrected this by removing the requirement for the exception file to be created in the DTS properties under "Options" tab. I could have added permissions as well but I took the easy route since I had already tested the packages and determined them to be performing as desired. I am not sure if this is the same in 7.0 though. Hope this helps...

-- Anonymous, July 11, 2001

Moderation questions? read the FAQ