Stan Kulp


Generate two-dimensional QR Code® bar codes in an SSRS report

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.

4.76 (38)

2016-09-05 (first published: )

11,310 reads

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: )

16,912 reads

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

4,708 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Export nvarchar(4000) to Excel

By Sailor

I'm trying to use the SSMS 18.7.1  Export Wizard to export to an Excel...

not able to use my user defined function

By DaveBriCam

I have a function I have created and need some help in how to...

SSRS site settings security and Home folder Security

By graham.measures

I am rewriting 100 or so reports on a SSRS 2012 server and migrating...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers