Retail Record ETL Solution

Project Tools

  • Active Batch
  • Integration Services (SSIS)
  • Microsoft SQL Server 2012

Project Details


Customer profile

Large Local Twin Cities Retailer, global operations, global online sales.


Customer’s challenge

Our customer needed a mechanism to validate and load multiple new vendor flat files that contained different headers and trailers and multiple record types; adding complexity to the validation and loading process. They also needed a way to quickly code changes in file layouts.


Tail Wind partnering

  • Tail Wind partnered with our customer to design and develop a custom ETL solution.
  • Working with a Tail Wind Sr. BI Architect and Lead Developer, they selected Microsoft SQL Server 2012, Integration Services (SSIS) for this solution.
  • We designed a standardized metadata driving process using SSIS packages and SQL Server 2012.