November 17, 2006 at 4:47 am
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."
November 20, 2006 at 8:00 am
This was removed by the editor as SPAM
November 20, 2006 at 2:50 pm
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.
November 20, 2006 at 3:43 pm
It's also helpful to 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...
Greg
Greg
November 21, 2006 at 4:05 am
Hi guys, thanks for the reply. i;ve set up both logs and i will be able to see what other information its going to provide me with when the package fails again but am hopingit won't as it has worked fine this last few days.
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy