Thanks a lot for this powerful alternative, I cannot test it right now but makes perfect sense and I'll surely give it a try soon.

I had a very complete overview...

Hi Everyone

I just found that in some cases the OLEAutomation check fails, giving me the "green light" when the file is still being copied

I've gone through the CLR solution with...

OTF (9/13/2012)

---

To by pass OLE Automation which you would typically want to do anyway you can put code along these

lines in a SQL CLR Function to test for the readiness...

Thank you too Jeff, this can be a good solution too!

Wandering around the web I found that OLE Automation could be a solution, so I want to share this

I created a function that returns "0" if the file is free...

Thanks

The problem is that I don't have any power over the file generation and getting the flag file from the client could take a lot of time.

I was hoping for...

The reason why decimal(4,4) doesn't work is because the scale is equal to precision, and that doesn't fit with the number format you have.

http://msdn.microsoft.com/en-us/library/ms187746.aspx