Event Watcher Task

I have two things that i need to perform in my SSIS package and they are both related to events that need to occurr before my package kicks off

1. Wait for a text file to show up to kick off my job. I know that there is a "File Watcher Task" that is available but I am unable to install anything on a production server does anyone know of an alternative that would provide the same functionality. I know that you can use the for loop container but it does not work for a file that does not already exist. I need it to wait for the file and when it show up to start the job. The file is also on a network drive which makes this difficult also.

2. I have a record in a table that shows up and I need to monitor this table and kick off the job when the record is inserted into the table.

Does anyone have any ides on these two items?
earngreenAsked:
Who is Participating?
 
Reza RadConnect With a Mentor Commented:
It is good scenario too,
the sample package you referred will check if the file exists or not,
now you can run this package on a schedule, this scheduling can be a job scheduling or service scheduling .

Regards,

0
 
Reza RadCommented:
this is good scenario:

   1. Create a Windows Service
   2. Use System.IO.FileSystemWatcher to monitor the directory and subdirectories for changes
   3. Launch SSIS packages programmatically from the Windows ServiceCreate a Windows Service
      Use System.IO.FileSystemWatcher to monitor the directory and subdirectories for changes
      Launch SSIS packages programmatically from the Windows Service

reference:
http://www.windows-tech.info/15/588d15818c99653b.php

0
 
Reza RadCommented:
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
earngreenAuthor Commented:
I saw the WMI EVENT WATCHER but this does not work well with the UNC path.
0
 
Reza RadCommented:
could you make a network map drive, and test it with this instead of UNC path?
0
 
earngreenAuthor Commented:
I think that for that peice of it i am going to try this example

http://blogs.pragmaticworks.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis

and then have the job schedular run every 15 minutes to check for the file.
0
All Courses

From novice to tech pro — start learning today.