Getting started with SSIS External Configuration File
This article illustrates how to use an SSIS external configuration file to enable the properties of package objects to be dynamically updated at run time.
2023-02-24
Integration Services
Execute SSIS Package with SQLCMD and Parameters
In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.
2020-12-23
SSIS: Read Event viewer with WMI Data reader
Access OS event viewer and read it from a SSIS package using WMI Data reader task
2019-03-05
1,632 reads
SSIS Basics: Data cleansing using derived columns
On this article I will show you how to perform a basic data cleansing using the derived column data transformation
2018-10-30
5,273 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers