dbTalk Databases Forums  

semaphore timeout

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss semaphore timeout in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Jayaseelan
 
Posts: n/a

Default semaphore timeout - 07-07-2004 , 11:05 AM






Hi,

The following error appears intermittently in the DTS log file. Any idea
what could be the issue.


Step Error Source: Microsoft Data Transformation Services Flat File
Rowset Provider
Step Error Description:Error opening datafile: The semaphore timeout
period has expired.


Thanks,


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: semaphore timeout - 07-07-2004 , 11:51 AM






I have seen mention of this type of message in 2 areas

1. Slow link when retrieving a file
2. The name of the file is > 128 characters.

Does either of these apply



Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.