Post reply

Can FileWatcher Task Process Without Creating a Job

  • November 17, 2009 at 4:36 pm

    #385805

    I created a package using the filewatcher task. The question I have is:

    Can the package auto process anytime a file is found in the specified folder or does it require a job to trigger the process?

  • November 18, 2009 at 3:03 am

    #1080757

    you need to have some process that will run the package. Installing a package on a server is not much more than simply copy the .DTSX file to the server.

    Whether you want to run the package using SQL Agent or not is your call but it is one of the easiest ways to do it. You can write code to execute the package if you want and then schedule that code (e.g. with Windows Scheduler) or you can get it to run with the DTUTIL utility.

  • November 18, 2009 at 3:06 am

    #1080758

    Oops, that should be the DTEXEC utility

  • November 18, 2009 at 9:49 am

    #1081015

    I would say that someone named the task wrong then.

    It isn't really a File Watcher, its a file checker.

    If it doesn't listen on it own, then it really doesn't keep a watch on anything; very misleading.

    It is no different than writing the action in a script task; as I was doing before.

    My understanding now is that no package can trigger on it own, it requires some scheduler to assist.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply