SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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!

Enjoy!

© 2017, John Morehouse. All rights reserved.

John Morehouse | Sqlrus.com

John Morehouse is currently a Database Architect with Farm Credit Mid-America out of Louisville, KY. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. He is also heavily involved with the Professional Association of SQL Server (PASS). In his spare time, you can usually find John reading up on SQL Server topics as well as chasing his two boys around the house.

Comments

Leave a comment on the original post [sqlrus.com, opens in a new window]

Loading comments...