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