Delimited flat files are commonly used to move data from one system to the other.

In this two part series published on SQLServerCentral.com, you’ll learn:

1. A design pattern to load flat files to staging tables
2. Automatically create packages to load multiple flat files using this pattern

Both these articles are written in great detail. And all of the code is available for you to use in your environment.

I hope you find this useful. Let me know in the comments if you run into any issues. I’ll be more than happy to help.