- Active Batch
- Integration Services (SSIS)
- Microsoft SQL Server 2012
Large Local Twin Cities Retailer, global operations, global online sales.
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.