Quick one today:

Recently, there was an interesting request. We have an application that stores shopping receipts in database table in binary format. To run some ELT processes on the content, we needed gather all the receipts; To be transferred ETL team. Seems like a simple task, but there was no ready template to generate all this data. We have about 10 million receipts will new 2 million receipts each day.

There are many ways to do this, but here we cover two ways:

• Using SSIS : Convert VARBINARY column data into raw files using SSIS
• Using T-SQL : Convert VARBINARY column data into raw files using TSQL

Hope this helps,
_Sqltimes