2 docs tagged with "excelfile"

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.

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.