SQL Server Performance Forum – Threads Archive

DTS job fails

I get the following error message when a DTS Package is executed from jobs. Well the user
CACIsvcPM2SQL is not part of admin group on the sql server machine. however it is a sysadmin with sql server. any idea what could be going on here? Executed as user: CACIsvcPM2SQL. …nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 5000 Rows have been transformed or copied.; PercentC… Process Exit Code 1. The step failed.

KBA to troubleshoot:
http://support.microsoft.com/?id=269074
http://support.microsoft.com/?kbid=290077 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>