Learn how to export relational source to CSV files in SSIS. Generate CSV files dynamically from Tables/Query. Learn more http://zappysys.com/products/ssis-powerpack/ssis-export-csv-file-task/
============================
This video covers
============================
◾ How to export multiple tables to CSV files from any data source
◾ How to export query output to CSV files
◾ How to split files based on row count / size or groupby column
◾ How to compress exported files in GZip format
============================
SSIS Export CSV File Task (Dynamic CSV File)
============================
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.
Features
◾Export multiple tables/views to CSV files (e.g. Sales% or do SalesJan|SalesFeb)
◾Export SQL query output to CSV file
◾Completely dynamic approach without limitation of DataFlow Strict Metadata
◾Split exported CSV data into multiple files by Size or Number of records
◾Split data into multiple files based on value from specific column (e.g. If you exporting customers and you specify SplitBy=Country then create new file for each country will be created for customer data)
◾Support for Compression and Append
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
