10 docs tagged with "etl"

Automate ETL pipeline generation using metadata-driven development with Biml

Generate SSIS packages programmatically with Biml automation

Essential C# programming concepts for automating ETL pipelines with BimlScript

Reusable BimlScript patterns for data engineering

Reads INFORMATION_SCHEMA for a configurable source view to optionally drop and recreate the destination table, then emits an SSIS package that truncates the staging table, optionally drops and rebuilds its indexes via stored procedures, and loads it from the view via an OLE DB source-to-destination dataflow with FastLoad.

XML fundamentals for data engineers learning Biml

Automate ETL pipeline generation by embedding C# or VB code in Biml

Complete LINQ reference for filtering, transforming, and querying Biml metadata

Reduce package creation time from 15 minutes to 15 seconds using variable replacement

Automate ETL pipeline generation with Biml - a practical guide for data engineers