Stan Kulp


SQLServerCentral Article

Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.

4.43 (28)

2016-01-22 (first published: )

18,093 reads

SQLServerCentral Article

Encrypt a file from SSIS using the Advanced Encryption Standard (AES)

This article demonstrates how to create a CLR assembly that can encrypt or decrypt a file with AES-256 cryptography, how to reference the CLR assembly from an SSIS script task, and how to generate an MD5 checksum file so that its recipient can confirm the integrity of the encrypted file.

4.92 (12)

2014-05-13

5,648 reads

Blogs

Updates from Coping Tips

By

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group

By

In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?

By

With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs

Forums

Server related questions

By albstaten

Hi, could someone answer the following questions please? I've googled of course but I'm...

MS SQL Server 2012 question regarding SSIS

By kyoto5

OK so I have a customer with a hosted website with eCommerce options. Essentially...

What's your opinion about Google Cloud SQL?

By mavalgreb

Hi, I wonder what your opinion about Google Cloud SQL is! We are a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers