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,694 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,420 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

17,474 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

6,240 reads

Blogs

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

By

As data becomes the backbone of modern business, understanding how to manage and analyze...

Simplify Kubernetes Security With Kyverno and OPA Gatekeeper

By

Here’s how these tools can make Kubernetes security easier and help you avoid common...

Read the latest Blogs

Forums

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Using Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using Heaps

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers