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)

You rated this post out of 5. Change rating

2016-01-22 (first published: )

19,208 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)

You rated this post out of 5. Change rating

2014-05-13

6,148 reads

SQLServerCentral Article

How to create an SSIS conditional data flow task

This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task.

4.36 (33)

You rated this post out of 5. Change rating

2014-04-10

16,266 reads

SQLServerCentral Article

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.

4.82 (22)

You rated this post out of 5. Change rating

2013-10-07

5,983 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

what does this error mean?

By water490

I was running a SP and I got this.  This is the first time...

how to properly index?

By water490

I am not sure how to decide on how I should index my tables...

Software Updates, Outages, Processes, and Protocols

By Ryan Booz

Comments posted to this topic are about the item Software Updates, Outages, Processes, and...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers