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?