Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query
This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.
2017-04-11
12,022 reads
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.
2016-09-05 (first published: 2014-01-14)
15,681 reads
Execute a data-driven SSRS subscription from SSIS to archive a report
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
2016-06-30
4,947 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.
2016-01-22 (first published: 2014-02-11)
19,842 reads
Trigger an Email of an SSRS Report from an SSIS Package
This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.
2015-06-19 (first published: 2013-03-19)
28,139 reads
Dynamically change background color in SSRS reports using custom code
This article demonstrates the use of custom code and cell expressions referencing that custom code to toggle the background color of groups of rows in an SSRS report based upon value-changes in one of the fields.
2014-10-27
34,839 reads
SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)
This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.
2014-07-22
13,566 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.
2014-05-13
6,523 reads
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.
2014-04-10
17,978 reads
SFTP, encrypt or compress data files in SSIS using custom components
SQL Server Integration Services does not provide native SFTP, encryption or archiving task components. This article presents a set of open source custom task components that provides these functions.
2014-03-13
8,661 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers