Quote:
have a dts package that is run by a scheduled job which was running
successfully for several months and suddenly stopped working.
>
The dts package does the following: Truncates the table, does a data
pump from a specific excel file to a table on sql server, deletes the
excel file. The job does the following:
>
>
Step 1: Look to see if a file exists and if so, run the dts package. On
>
success of this step the job goes to step 2.
>
>
Step2: Looks to see if any files still exist after the first step
Step3: Failure notification. To be triggered on failure of step 1 or
2.
>
>
The owner of the job is the Account that is used to run the
SQLServiceAgent and in the SysAdmin server role.
>
>
The owner of the job is also in the SysAdmin server role.
>
>
Both the accounts are Windows Accounts.
>
>
The job runs at schedule time, finds the file, and runs the dts
package. The first part of the dts package runs successfully - The
table is cleared. However it is not doing the data pump part. There
are no failure notifications. The job then goes to step two and sends
a message that the file still exists. The dts task is set to output an
>
error file which is not being updated, which tells that the task is not
>
executed. If the dts package is run manually, then the package runs
successfully.
>
>
Any help would be appreciated.
>
>
Thanks
KR
what error does the job throw.kindly post the error.
