Re: File Watcher Task
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Jun 2007 20:15:39 +0000 (UTC)
Hello CraigHB,
When you say "a FileWatcher Task" do you mean
File Watcher Task
(http://www.sqlis.com/23.aspx)
If it is then we only fire the task once.
That said you could put it in a loop.
Another option would be to have a windows service do the file watching and have it fire a package rather than have the package do the watching and firing.
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com
If you use a File Watcher task to watch a folder for files added and
1000 files get copied to that folder, does the package try and run
1000 times in parallel?
I want to build a process that will import files one-at-a-time and get
started when a batch of files arrives in the source folder. Is this
possible?
.
- Prev by Date: Re: cannot import some cells into SQL2000
- Next by Date: Re: SSIS Script Component: How do I write code leave column/field as NULL
- Previous by thread: Re: cannot import some cells into SQL2000
- Next by thread: Problem with dts and network error
- Index(es):
Relevant Pages
|