September 13, 2012 at 6:53 am
I am using this file watcher task:
http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx
When my user places a file in a directory it fires off and sends the file via FTP.
Works fine, but my question/problem is I need for my package/job to run 24 hours a day. How do I schedule this as job? Do I schedule the job to run every minute? Then if I do that it sends an error (because there is no file there)
Do I just turn off the error notification? Or is there a better way I'm not thinking of?
September 13, 2012 at 10:23 am
krypto69 (9/13/2012)
I am using this file watcher task:http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx
When my user places a file in a directory it fires off and sends the file via FTP.
Works fine, but my question/problem is I need for my package/job to run 24 hours a day. How do I schedule this as job? Do I schedule the job to run every minute? Then if I do that it sends an error (because there is no file there)
Do I just turn off the error notification? Or is there a better way I'm not thinking of?
If there is no file, the job should not complete - it should just pause while the FW is waiting for the file to appear. What is the error message?
September 13, 2012 at 10:46 am
Here's the error..works fine if a file is there..
Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code: 0x00000000 Source: File Watcher Task FileWatcherTask Description: The Path specified is not a valid directory. Please check directory exists and has appropriate security permissions (N:\CitiStreet_PGP_Source\401K). End Error Error: 2012-09-13 12:31:00.10 Code: 0xC0024107 Source: File Watcher Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:30:59 PM Finished: 12:31:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
September 13, 2012 at 11:22 am
krypto69 (9/13/2012)
Here's the error..works fine if a file is there..Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code: 0x00000000 Source: File Watcher Task FileWatcherTask Description: The Path specified is not a valid directory. Please check directory exists and has appropriate security permissions (N:\CitiStreet_PGP_Source\401K). End Error Error: 2012-09-13 12:31:00.10 Code: 0xC0024107 Source: File Watcher Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:30:59 PM Finished: 12:31:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
Presumably the directory does exist all the time?
Have you tried using a UNC path rather than N:\...?
What have you put in the 'path' property of the FW task?
September 13, 2012 at 1:38 pm
The directory is there all the time.
I'll try the UNC path.
Kinda wierd tho, cause it does work fine when the end user drops a file in..
September 14, 2012 at 12:24 pm
UNC path worked...thanks!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy