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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply