sql server dts: 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

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

[quoted text, click to view]