Required software development,Website Development freelancer for SSIS SQL ETL Process job

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

Skills & Expertise Required

software development Website Development