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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-10 : 07:58:59
|
| Geoff writes "I have DTS jobs running on SQL 7.0 sp3 (Windows NT) that have suddenly started failing with 'Process Exit Code 5'. Here is an example of the job step history for a simple package to copy tables -... DTSRun: Executing... DTSRun OnStart: Create Table [tbcnew].[dbo].[me_ivcstlay] Step DTSRun OnStart: Create Table [tbcnew].[dbo].[me_ivitem] Step DTSRun OnStart: Create Table [tbcnew].[dbo].[me_ivmark] Step DTSRun OnStart: Create Table [tbcnew].[dbo].[me_ivqty] Step DTSRun OnFinish: Create Table [tbcnew].[dbo].[me_ivitem] Step DTSRun OnStart: Copy Data from ivitem to [tbcnew].[dbo].[me_ivitem] Step DTSRun OnFinish: Create Table [tbcnew].[dbo].[me_ivcstlay] Step DTSRun OnStart: Copy Data from ivcstlay to [tbcnew].[dbo].[me_ivcstlay] Step DTSRun OnFinish: Create Table [tbcnew].[dbo].[me_ivmark] Step DTSRun OnStart: Copy Data from ivmark to [tbcnew].[dbo].[me_ivmark] Step DTSRun OnFinish: Create Table [tbcnew].[dbo].[me_ivqty] Step DTSRun OnStart: Copy Data from ivqty to [tbcnew].[dbo].[me_ivqty] Step DTSRun OnProgress: Copy Data from ivmark to [tbcnew].[dbo].[me_ivmark] Step; 1000 Rows have been transformed or copied.; Perc... Process Exit Code 5. The step failed.Can anybody help me with a clue as to what this means ?" |
|
|
|
|
|
SQL 7.0 DTS Exit Code 5