Generate multiple CSV files in SSIS Dynamically (Split by size-rows, Compress GZip)

Generate multiple CSV files in SSIS Dynamically (Split by size-rows, Compress GZip)

Learn how to export relational source to CSV files in SSIS. Generate CSV files dynamically from TablesQuery. Learn more br br ============================ br This video covers br ============================ br ◾ How to export multiple tables to CSV files from any data source br ◾ How to export query output to CSV files br ◾ How to split files based on row count size or groupby column br ◾ How to compress exported files in GZip format br br ============================ br SSIS Export CSV File Task (Dynamic CSV File) br ============================ br SSIS Export CSV File Task is your one stop solution to create multiple CSV files (Flat Files) from SSIS. Say good bye to all MetaData related issues in DataFlow. We worked hard to take care most painful problems for exporting data from relational source (e.g. SQL Server, MySQL) to CSV. br br Features br ◾Export multiple tablesviews to CSV files (e.g. Sales or do SalesJan|SalesFeb) br ◾Export SQL query output to CSV file br ◾Completely dynamic approach without limitation of DataFlow Strict Metadata br ◾Split exported CSV data into multiple files by Size or Number of records br ◾Split data into multiple files based on value from specific column (e.g.


User: Zappysys

Views: 9

Uploaded: 2016-04-04

Duration: 06:34