Connection managers are the gateway for most SSIS reads and writes. In Notes from the Field #088, Tim Mitchell explains how to use Project Connections in SSIS.
SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084
Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.
SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080
In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.
SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079
Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.
SQL SERVER – The Basics of the File System Task – Part 2 – Notes from the Field #075
Andy Leonard returns with part 2 on the basics of the File System Task in SSIS, useful whenever your data moves to and from flat files.
SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071
Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.
SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070
Tim Mitchell explains how using raw files in SSIS helps when data cannot simply be processed on the fly in a single data flow pipeline.