Adds a sequential row-number column to a flat-file export by piping an OLE DB source through a Script Component transformation that increments a counter for every row, so downstream business users have a stable line reference when reporting issues with the file.
Reads INFORMATION_SCHEMA from a SQL Server source to generate a per-table FlatFileFormat, FlatFileConnection, and OLE DB to FlatFileDestination dataflow, producing one delimited extract per base table in the chosen schema.
Two paired BimlScripts that scan a folder of delimited files, read each header row, then generate matching SQL staging tables and per-file SSIS import packages (flat file connection, file format, and dataflow) for every file in the directory.
Configurable BimlScript that introspects a stored procedure resultset using SET FMTONLY ON, then generates an SSIS package that runs the procedure and writes the output to either a timestamped CSV file (FlatFileDestination) or an Excel workbook (ExcelDestination via Jet or ACE), including a script task that injects 'GETDATE()' tokens at runtime and a generated CREATE TABLE for the Excel sheet.
Declares a standalone FlatFileFormat asset with typed columns and per-column delimiters that can be referenced by one or more FlatFileConnection objects.
Reads a SQL Server schema's tables and column types, then emits one package per table with a matching FlatFileFormat and FlatFileConnection whose typed columns mirror the destination table, so flat-file imports get data-type validation at the connection manager.
Reads the first line of a delimited file as a single 'FileInfo' string, routes it through a Conditional Split that compares against known header signatures, counts rows on each branch, then uses a precedence-constraint expression on a non-zero row count to fire the matching per-layout Dataflow task.
Reads 'SurveyResponses' and 'JuniorSurveyResponses' from a SportsSurvey OLE DB source, merges them with a UnionAll transformation, and writes the combined rows to a semicolon-delimited flat file via a FlatFileFormat and FlatFileConnection.