September 23, 2005 at 10:14 am
I have a package that uses a transform data task which only produces the following error when I run the package as a schedule job. When I run it interactively I don't receive this error.
I have been told that it may be a permissions or security issue. The owner of the SQLAgent service is sql-sa which is in the sysadmins group and sql-sa has read/write ultimately where this data is written too.
If anyone has an ideas or suggestions, I would greatly appreciate it.
Frank
Executed as user: EXLLLC\sql-sa. ...OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5282 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5282 ... Process Exit Code 1. The step failed.
September 23, 2005 at 12:14 pm
Does this step send out an email? I've seen this same error scenario when the task works but the email fails. If that's the case, make sure the sql-sa user has a mail profile on the server.
September 23, 2005 at 3:10 pm
David:
I tried your suggestion and so far it seems to work. I did create a light weight version of my DTS package, so I will need to add back the remaining functionality but hopefully the result will be positive.
Again, Thanks for the feedback.
Frank
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply