Wise Owl Training - SSIS blogs (page 1 of 2)

A way to get 32-bit and 64-bit drivers to co-exist on the same computer

Posted by Andy Brown on 21 September 2018

A (very) short blog containing a link to an article showing how you can import data from Access using SSAS or SSIS on a 64-bit computer

This blog shows a clever way to annotate expression constraints in SSIS

Posted by Andy Brown on 27 April 2017

If you've added an expression constraint to control flow in a package in Integration Services, this blog will show you how to display what the constraint does automatically.

How to loop over the worksheets in an Excel workbook using Integration Services

Posted by Andy Brown on 21 April 2017

Follow this blog to learn how to use an SSIS package to loop over the worksheets in an Excel XLSX workbook, importing the contents of each.

Using SSIS to loop over the worksheets in an Excel workbook, importing each

Posted by Andy Brown on 07 April 2016

Looping over Excel workbooks is one thing, but how can you loop over all of the worksheets in a single workbook, importing the contents of each? This blog explains the steps you need to follow.

Unpivoting data in SSIS using the Unpivot transformation

Posted by Andy Brown on 07 April 2016

If you've been given the output from a pivot table or a cube, you can collapse it back into its original state using the UNPIVOT transform in Integration Services.

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 and when to use the Execute SQL task PARSE QUERY button in SSIS

Posted by Andy Brown on 18 September 2015

A short blog explaining how the Parse Query property and BypassPrepare property for an SSIS task are related.

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.

Ideas for encrypting data in transit in SSIS

Posted by Andy Brown on 08 February 2015

How can you encrypt data flowing within an Integration Services package? We don't think you can, but here are a couple of ideas.

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.

How to refer to parameters by name, not number, in SSIS

Posted by Andy Brown on 30 January 2015

Referring to parameters by their numeric position in a list in SSIS is relatively easy, but there is a way to refer to them by name too, as explained in this blog.

Getting at file attributes from FOREACH loop in SSIS

Posted by Andy Brown on 30 January 2015

SSIS makes it easy to loop over files, but it's less obvious how to get at file attributes such as the date created or last modified date. To do this you'll need a scripting task, as explained by this blog.

Steps to follow when creating a new flat file in SSIS

Posted by Andy Brown on 04 December 2014

Using an existing flat file in SSIS is straightforward, but creating a new one can be a pain - this blogs gives some steps to follow.

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!

What does the SCD transform in SSIS do, and should you use it?

Posted by Andy Brown on 05 July 2014

Integration Services include a Slowly Changing Dimension transform, which is designed to make loading dimension data easier. This blog explains how it works, and discusses whether it achieves its objectives.

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.

A blog to accompany our YouTube tutorial on script components in SSIS

Posted by Andy Brown on 19 February 2014

This blog provides the SQL, C# and VB script needed for the Integration Services script components tutorial.

Variable Scope in Integration Services 2012

Posted by Andy Brown on 16 April 2013

A quick blog on how to change the scope of any variable in SQL Server Integration Services 2012.

Problems connecting to Excel workbook from SSIS

Posted by Andy Brown on 16 April 2013

A short blog explaining why you might have problems connecting to an Excel workbook from SSIS.