December 10, 2011 at 12:11 pm
Hi All,
I have run across a problem I can't seem to find an answer for anywhere. I have a package that checks if a file exists and then based on whether it does or not either continues processing through the package or sends an email that the file hasn't been dropped in the folder yet. I am running SQL Server 2008 R2 Enterprise 64 bit. I had this working perfectly a few days ago and then all of a sudden the script task where the file checking takes place started hanging with a yellow status indefinitely. However, if i right click the task by itself and disconnect the constraints, it runs fine by itself. I also tried the Konesans file watcher task and it does the same thing. This happens whether the constraint succeeds or fails. I am at a loss here and am wondering if anyone else has experienced this?
December 12, 2011 at 3:16 am
There isn't a lock on the file or something like that?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 12, 2011 at 9:08 am
No, there is no lock on the file. It seems like a really fluky issue.
December 12, 2011 at 11:24 pm
LS-487884 (12/12/2011)
No, there is no lock on the file. It seems like a really fluky issue.
What happens if you step through the script with the debugger?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply