Skip to main content

3 docs tagged with "expressions"

View all tags

Conditional Splits in the Data Flow

Configure a Conditional Split transformation in Biml to route rows to multiple outputs based on expressions, with special handling for XML reserved characters.

For Each Loops with Biml over Flat Files

Generate an SSIS package that loops over every CSV file in a directory, imports each into a single SQL Server target table, and stores the file name with each row.