DTS Job Error
-
Why does the show as failed even when the o/p it generates is correct?
I have a job which renames a file and extracts data from the DB in to a text file and based on the status of the rename and extraction sends an email of success or failure to the user. The user says that the o/p in the file is correct. The job shows success on the test server but failure on the production server.
Is this a problem with SQL Server? or could it be the package itself?
TIA
-
You're going to have to do a little more digging. Enable package logging by opening the package in DTS Designer, click file, properties, Logging tab, check "log package execution to SQL Server" and name the local server.
After the package runs, right-click on the package name and select package logs. This will show you which package step failed.
Greg
Greg
-
it's usually a permissions problem... is the email being sent correctly from both your development and production environment? Does the account have correct access to your mapi profile?
-Mike Gercevich
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply