Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-11-15 : 03:40:13
|
| Hi My job fails but does not give me a valid reason on why it does here is the error messages am geting any help on this would be great. "DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1001 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1001 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 3000 Rows have been transformed or co... Process Exit Code 1. The step failed." |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-11-21 : 06:03:49
|
| Just as a way of updating the thread i've set up 2 types of logs to see what more information i can get from the failing job here is what i've done.The history of a SQL job step only shows so many characters. To get a log of everything that's happening in the step, create a step output file as follows:1) Right-click on the SQL job and select Properties.2) Go to the Steps tab, select the the step that executes your DTS package, and click the Edit button.3) Click on the Advanced tab and enter a path for a log file that will be valid on the server in the Output file text box.4) Execute the job then open the log file. You'll see more information than what the job history displayed.I've enable package logging in the DTS package itself. 1. Open the package in DTS Designer.2. Right-click in an open area and choose Package Properties.3. On the Logging tab, check 'Log package execution to SQL Server.After the package fails, you can right-click on the package in EM and select Package Logs... |
 |
|
|
|
|
|
Failing job