June 17, 2010 at 4:25 pm
I am new to SSIS.
Create an SSIS Packages that will read data from a Flat file in shared Directory and load it into Data Warehouse table.
This SSIS Packages should run whenever a new file is uploaded on to the directory i.e. from whenever a new file is added to the directory, an even should be generated. Whenever this event raise the package should be executed from the command line.
(a): Create a FILE WATCHER Service in Windows, so that if any file is added to that directory FILE WATCHER SERVICE should raise an event. Whenever this Event occurs SSIS Package should catch that Event along with the File Name and Package should be run from the command line.
Please help me how to create a package that catches the Event and FileName ?
June 17, 2010 at 4:47 pm
Will this help? http://www.sqlis.com/post/file-watcher-task.aspx
June 17, 2010 at 6:53 pm
Steve Jones - Editor (6/17/2010)
Will this help? http://www.sqlis.com/post/file-watcher-task.aspx
Thank you..
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply