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.
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.
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.
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.
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!
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.
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.
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.
Posted by
Andy Brown
on 30 January 2015
This blog explains how to send an email to every person returned from a SQL query.
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.
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.
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.
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.
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.
Posted by
Andy Brown
on 05 April 2013
How to store the name of each file in a folder in a SQL Server table using an Integration Services package.