File Watcher Task doesnt wait for the entire file to be completely finish before it complete

Hey there

Ive built an SSIS package which generates a file from a legacy system and then downloads the file into a designated folder on the server. I need the file watcher task to wait for a the file to completely finish loading before it says it is complete. Currently, as soon as the file is created, the WMI step finishes.

Any help would be greatly appreciated!

Kind Regards

David

Check out http://www.sqlis.com/default.aspx?23

Thanks,
Loonysan

|||

Hi

Thanks for that. We decided to take a different approach though.

Ive downloaded another file watcher task from Konesans. Konesans.Dts.FilewatcherTask.FileWatcherTask. I have added it into my SSIS package and it is working like a dream!

However, when to Add it to the SQL Server Agent, I get a strange error message (Package Execution Progress):

- -> Wait for File to Download

Validation has started

Error: The task has failed to load. The contact information for this task is "".

Error: There were errors during the task validation

Validation is completed

Any ideas of how to resolve this?

Thanking you in advance

David

|||

Konesans file watcher is the same one as http://www.sqlis.com/default.aspx?23

Please check if this component is installed in the machine where you are trying to execute the package via SQL Agent. It looks like the SSIS Package is not able to load the FileWatcher Task at runtime.

If the problem persists - contact http://www.konesans.com/contact.aspx

Thanks,
Loonysan