Where can I learn what is wrong with my SQL job or DTS package ?
Q: I am using SQL server and i configured a dts package that imports paradox database to my sql 2000 i scheduled the dts package for 3 times a day but it gives an unknown error that i can only trace in event logs and i cant get detailed error messages to fix it.Where can i learn what is wrong with my sql job or dts package ? where can i get a detailed error message??
Kevin Kline says: Well, you didn’t submit the error number on this, which would be more helpful, but in the meanwhile, here’s a general troubleshooting process to follow:
1. Write down the error number. If you don’t have the error number, write down as much of the error as possible.
2. Press Ctrl-PrtSc to save a screenshot of the error msg to the clipboard. Save it in Paint for later reference.
3. Go to http://support.microsoft.com
4. Click the hyperlink “Switch to Advanced Search” in the upper right corner of the frame. Then:
A. In the “Search Product” box, enter SQL Server, SQL Server 2000, or SQL Server 2005.
B. In the “For” box, enter the error number and/or the error message.
C. You should be able to leave the rest of the choices as-is.
D. Make sure that Include boxes are checked: How-to Articles, Downloads, Troubleshooting, Guided Help, MSDN content, TechNet Content.
5. Click Search.
Now, look at the links that are returned and choose the one(s) that work best for your problem.
Hope this helps
Technorati Tags:
SQL Server, error notification, DTS, troubleshooting