Microsoft SQL Server forum - The transaction has exceeded the allotted time

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

The transaction has exceeded the allotted time

AJA

2006-03-31, 7:33 am

Hello

I had that message in different steps:

Executed as user: HD1\Administrator. DTSRun: Loading...
Error: -2147467259 (80004005); Provider Error: 0 (0) Error
string: The transaction has exceeded the allotted time. Error source:
Help file: C:\Program Files\Common Files\Microsoft
Shared\Repostry\REPO
STRY.CHM Help context: 4164. Process Exit Code 1.
The step failed.

Last time i get this essage about 15 days before, and it was in other
packeges. It happened few times and all time in other packages in other
step.
This time it was when packages tried to copy data from 5 tables in one
database to secount database on the same server. I do not have idea why,
and what I have to do :(

Best regards
AJA

Sponsored Links