Creating SSIS Packages from a Stored Procedure (via BIML)
This Walkthrough presents a very fast technique to build a simple (Truncate and Load) SSIS package by leveraging a SQL Stored Procedure and BIML.
This Walkthrough presents a very fast technique to build a simple (Truncate and Load) SSIS package by leveraging a SQL Stored Procedure and BIML.
XML fundamentals for data engineers learning Biml
Declares two FileConnections (one for the XML file, one for the XSD schema) and binds the XSD connection's ConnectionString property to a package variable via an expression, so the schema path can be supplied at runtime.