Extract Data from Sage Sotamas 90 into SQL Server with Biml
Move Sage Sotamas 90 ProvideX data into SQL Server by generating destination tables from the vendor XSD, then producing one SSIS package per table with Biml.
3 docs tagged with "odbc"
View all tagsSchema Definitions from an ODBC Text Source
Use an ODBC text driver to expose a folder of flat files as tables, then read schema metadata to drive ETL generation.
The ODBC Destination in Biml
Define ODBC destinations in Biml using auto mapping, explicit column mapping, and per-column overrides.