Blogs from Wise Owl on General SSIS in SSIS

How to create dynamic connection strings in Integration Services packages

Posted by Andy Brown on 08 January 2016

It's often useful to make connections point to different Excel workbooks or SQL Server databases, depending on the value you set for variables or parameters. This blog shows the underlying principle - it's up to you then to apply this in your workplace!

How to run SSIS packages in 32-bit mode to avoid Excel and Access errors

Posted by Andy Brown on 08 January 2016

If you're using SSIS to import from or export to Excel workbooks or Access tables - as you surely will be - you'll need to run your packages in 32-bit mode. This blog explains why and how to do this.

How to lay out diagrams in SSIS packages to look neat

Posted by Andy Brown on 04 September 2015

Arrows in your Integrated Services packages can go all over the place - learn how to control them in this short blog on formatting SSIS diagrams.

How to send an email to every person in a SQL Server table

Posted by Andy Brown on 30 January 2015

This blog explains how to send an email to every person returned from a SQL query.

A detailed blog exploring what's new in SSIS 2012

Posted by Andy Brown on 27 November 2014

If you're wondering whether to upgrade to Integration Services 2012, or just want to know what differences there are between SSIS 2008 R2 and 2012, this blog should help you!

Thoughts on working with SSIS 2008 and SSIS 2012

Posted by Andy Brown on 12 March 2014

Some thoughts and advice to those who have to shuffle between versions 2012 and 2008 of Integration Services.