Hello,

I have a Windows 2000 server running two instances of SQL server, SQL7 and
SQL2000.

I have SQL7 agent jobs which execute sql script (step 1) and then copy the
table to another server (step2).

Typically, step 2 would produce successful output such as this:

[VlodgeNet].[dbo].[wpg_search_officer] Step DTSRun OnFinish: Delete from
Table [VlodgeNet].[dbo].[wpg_search_officer] Step DTSRun OnStart: Copy
Data from wpg_search_officer to [VlodgeNet].[dbo].[wpg_search_officer] Step
DTSRun OnProgress: Copy Data from wpg_search_officer to
[VlodgeNet].[dbo].[wpg_search_officer] Step; 1000 Rows have been transformed
or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress:
Copy Data from wpg_search_officer to [VlodgeNet].[dbo].[wpg_search_officer]
Step; 2000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 2000 DTSRun OnProgress: Copy Data from wpg_search_officer
to [VlodgeNet].[dbo].[wpg_search_officer] Step; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
OnProgress: Copy Data from wpg_search_officer to
[VlodgeNet].[dbo].[wpg_search_officer] Step; 4000 Rows have ... Process Exit
Code 0. The step succeeded.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

I recently added another instance of SQL 2000 to the server. Now, my step 2
output looks like this?

succeeded.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

This has happened for all my dts jobs which copy tables. This shouldn’t be
related to adding another instance of SQL2000?

Also, I don’t think this is a valid output, i.e., if step 2 fails, I believe
I would still get this “successful” message.

Does anyone have any thoughts on this? … on how to get my old output back?

Thanks,
Tom