Use File System Task Results in an Email

Here’s a simple how-to on emailing the results of a batch file execution to some email recipients in an SSIS package. Continue reading

SSIS’s different data types – a history

Have you ever wondered why SSIS has multiple data type systems and asked, “what were they thinking?!” Here’s what they were thinking… Continue reading

32-Bit ODBC Connections with 64-Bit SSIS

A few challenges encountered while creating an ETL process running in a 64-bit SSIS installation that required use of a 32-bit ODBC driver. Continue reading

“Text was Truncated” Error in SSIS Using Excel

One way to solve a “Text was truncated…” exception when importing data from Excel to SQL Server via SSIS. Continue reading

SQL 2005 – Maintenance Plan: Database Integrity Check

I have a standard maintenance plan I use on my SQL Server 2005 instances.  That plan includes the Check Database Integrity Task which I run on all databases.  Recently, this task began failing on one of my test servers with this … Continue reading

Using the Excel 2007 provider in 64 bit SQL Server 2008

I recently created an SSIS package in my 32 bit BIDS on my workstation that connects to an Excel 2007 xlsx file that transfers some data to a 64 bit SQL Server 2008 instance.  When I ran this package on … Continue reading