Thanks.

That's a solution that I can use! I added a SQL task (following the transform data task) that counts the records using the same query and setting a global variable....

Thanks for your reply!

At this moment I limit myself to creating DTS packages with the graphical interface of DTS Designer in SQL Server Enterprise Manager using Connections, Transform Data Tasks...

OK. Count(*) is correct. The problem is in the job that failes sometimes (approximately in 20% of the cases).

I got the following message from the job history by phone:

"...generated fatal...

Thanks for your replies!

The jobs run on a server I cannot access directly from my office. I can only access a table with log messages the stored procedures creates.

If the...