The rows will then be inserted into an SQL table.<BR><BR>Now, I've begun building the package using a ForEach container and having that looping through a directory pulling the filenames to a variable.

PowerShell Basics: Programming With Loops In this PowerShell guide, we explain how to use the For loop, the ForEach-Object loop, and the While, Do-While and Do-Until loops.