SSIS SQL ETL Process

Create an ETL process to pick up flat files and import them into a staging database in SQL server.

The flat files we receive are stacked flat files which means they have multiple Row Types per file.

Each row will have a fixed total length but a Row Type could have different columns and column lengths.

Each Row Type will go into their own table in the database.

Row Type is determined by the first 2 characters of each row.

We have documents that state the column length and start position of each column per Row Type per file.

We have SSIS skills in-house so we would like it built in SSIS so we can maintain it moving forward.

There should be a relatively easy way for us to add additional files in the future
About the recuiter
Member since Jul 10, 2017
David
from England, United Kingdom

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions