SQL Server Integration Services Training Video - How to Loop Thro ugh All Files in a Folder and Load Into SQL Server, Part 5

SQL Server Integration Services Tutorial: How to Loop Through All Files in a Folder and Load Into SQL Server, Part 5

This SSIS 2008 tutorial comes from the LearnItFirst IT Training Video Library.

How to Loop Through All Files in a Folder and Load Into SQL Server, Part 5 (Tutorial Video)

More info about this video:

This is the last video covering looping all files in a folder to load into SQL Server.  Now that the package is almost done, the last thing to do is specify when it will actually run.  There are several techniques to watch for the arrival of a file.  In this video Scott will show you how to use the WMI Event Watcher Task to watch for when a file arrives. 

Highlights from this video:

• How do we figure out when a file arrives?
• WMI Event Watcher Task
• Foreach loop
• .NET code
  
• Using the WMI Event Watcher Task
• Why did Scott choose this technique?
  
• Writing WQL queries
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Integration Services training course.