File watcher task question

  • Unless this needs to be done in (near) real time, a scheduled package containing a simple foreach loop should be sufficient for your needs ...

    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

  • I need it in real time only.

  • You can find the FileWatcherTask on http://www.sqlis.com

  • For those of you who have implemented this File Watcher Task - do you think it's better to use this file watcher task or go with the standard wmi watch task from an out of the box installation?

    I looking at this more from a risk factor of implementing components/tasks that are not shipped with SSIS as standard.

    Is using the WMI Watch event that much more involved?

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • Not sure why you would limit yourself to only out of the box components? SSIS is designed to be extensible, allowing you to develop or purchase custom components to extend the power of SSIS.

  • well, I don't really want to limit myself - my question is more - from yours (and others) experience do you get issues with some of these additional components and tasks?

    Simplified: can it be more hassle in the long run using custom compents or is that not your experience?

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • Installed it from:

    http://www.sqlis.com/post/File-Watcher-Task.aspx

Viewing 7 posts - 16 through 21 (of 21 total)

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