Extract Query result from SQL server in SSIS into CSV flat file , Compress CSV and send the CSV File by email
I have a query to extract records of about 7 million rows in SSIS from SQL server. I then need to dump the data as CSV , and then compress the CSV file to be able to mails it using my smtp server with the send mail task.
The tricky part is : How to compress the CVS fils in SSIS possibly using a Script component.
Your help is appreciated .Other solutions will be accepted apart from my requested solution.
Web Languages and StandardsMicrosoft SQL Server 2008C#