SSIS – Adding Connections

Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run into something like this I am going to write a quick blog about it.  It’s something new I’m trying

While recently examining an existing SSIS package  before implementing some needed changes I noticed the connection manager for multiple flat files.

Normally, when processing multiple files, I use a sequence container and loop through them.  It’s usually a cumbersome process to setup and you must configure variables.  I was not aware the multiple flat file type of connection manager existed. No wonder because it’s notwithin the normal list.  This handy thing could only be found when I looked under “New Connection”.

Right click in the blank space in the Connection Manager and select “New Connection” from the resulting dialog window.

Suddenly a whole new list of connections is now available!

Just a reminder that it benefits, at times, to click around to discover new things!


© 2017, John Morehouse. All rights reserved.

One Reply to “SSIS – Adding Connections”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.