Experts, We have a Excel file with 2 columns and 10 rows (a simple Excel file), through SSIS we are loading this Excel File into SQL Table, and finally we are reading above Excel file through SQL object as "SELECT * FROM TABLE-NAME". Now suppose the excel file is modified say for example it has deleted 2 rows or it has added 2 more rows in any case we wan't the SSIS package to kick-off the every next second such that SQL is updated respectively. My question is How can I kick-off the job once the file is been modified otherwise the job shouldn't do anything at all. Can anybody help me out? I hope I made you cleared, if not please do let me know. Thanks KumarKG, MCTS

Running a package from within an Excel spreadsheet on every row added / deleted seems to be not a very good idea, but doable. You would use DTExec command on the client embedded into an Excel macro like discussed here: http://www.mrexcel.com/forum/showthread.php?t=80626 Arthur My Blog

Hello Experts, First we thought of doing by staight SQL query using "Bulk Insert", "Openrowset" & also using "Recursive CTE"/"Itteratice function" but nothing is working, cause:- 1. We first we ran into Jet provider issue, as we have all 64-bit sql server, http://social.msdn.microsoft.com/Forums/en/transactsql/thread/a2d32670-3b52-46f4-919d-7ea3a7e213b5 2. Than we fan into Keberos/Delegation issue:- http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b2c5cf95-080f-4cea-9a04-5981bfc00f87 Currently we are trying if we can handle using BizTalk, but still I wan't try if we can handle my situation with SSIS than please do let me know. Our users add/modify/delete files rows very frequently and so we need to add/modify/delete those rows apprantely into SQL table, such that they can use the same update SQL table into their next Brio Query for grouping/manuplation very next moment. Please help me out. Thanks KumarKG, MCTS

Hello again, Here is the sample thread which have described what I'm requesting, but looks like this is a custom task where we need to download and install into current enviorment. http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/ce487bed-d38c-427b-b87a-4ddcf1c6ddb9 Is their any way were I can handle the same situation within SSIS current enviornment, we are using below version:- Microsoft Visual Studio 2008 Version 9.0.30729.4462 QFE .NET Framework Version 3.5 SP1 Microsoft SQL Server Integration Services Designer Version 10.50.1600.1 Please let me how to achieve it? Thanks KumarKG, MCTS

you can use WMI Event Watcher task which don't need to install any other thing, sample WMI queries to watch a folder or file is : FOR INDIVIDUAL FILE : SELECT * FROM __InstanceCreationEvent WITHIN 60 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Name = 'c:\\ImportData\\test.txt' FOR WATCHING A FOLDER : SELECT * FROM __instancecreationevent WITHIN 60 WHERE TargetInstance ISA 'Cim_DirectoryContainsFile' AND TargetInstance.GroupComponent='Win32_Directory.Name="c:\\\\ImportData"' reference: http://www.sqlservercentral.com/Forums/Topic473313-148-1.aspxhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Hi Reza, Wow looks like I can make this out using your reply. I'll update this thread once I'm done with it. Thank You for your prompt responses. KumarKG, MCTS