Starting SSIS package execution when entering files in a folder

Question

I have a script in SSIS. I have a package that is simply moving data from a flatfile to a database. I have a specific location and I want to execute this package when the file is in a folder.

Answer 1

Step by Step Using the WMI Event Watcher Task

• Create a WMI Connection Manager. Use Windows credentials at startup locally (you must be an administrator to access WMI event information) and enter credentials at remote startup (be sure to encrypt your packets!).
• WMI. WQLQuerySource WQL .

WQL SQL-, , , :

SELECT * FROM __InstanceCreationEvent WITHIN 10 
WHERE TargetInstance ISA "CIM_DirectoryContainsFile" 
and TargetInstance.GroupComponent= "Win32_Directory.Name=\"c:\\\\WMIFileWatcher\"" 

, escaping, .

3. WMI. Foreach , .

4. " " " " .

5. (, ConnectionString ), .

, , .

, For EvalExpression, true == true.

PowerShell SSIS . , .

Answer 2

WMI , / . ForEach Loop Container Execute SQL Wait, For Loop Container.

ForEach, , . - Script, Files_Found - , .

ForEach Loop Container SQL Execute , . WAITFOR DELAY '00:05:00' 5- .

ForEach Loop Execute SQL For Loop, Files_Found.

- - , , , WMI.