BY TOPIC▼
SQL SERVER BLOGS▼
SSIS BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on General SSIS in SSIS
Showing blogs 1-7 (out of 7)
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
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.