2 docs tagged with "csv"

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 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.