Hi,

I tryed to run DTS with Report Preparation Task. And it
stucked with running Report Preparation Task for more than
an hour, so i had to cancel execution of DTS.

Couldn't find any reason why it happened in Package Logs
or event logs, or sql logs.

Maybe anyone had experienced same problem and/or know
reason of this problem.

See if there's any blocking going on in your database, using sp_who or
sp_who2.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"Svetlana" <svetle_k13 (AT) hotmail (DOT) com> wrote

Hi,

I tryed to run DTS with Report Preparation Task. And it
stucked with running Report Preparation Task for more than
an hour, so i had to cancel execution of DTS.

Couldn't find any reason why it happened in Package Logs
or event logs, or sql logs.

Maybe anyone had experienced same problem and/or know
reason of this problem.