SQL Server Source Patterns - SQL Server Integration Services Design Patterns - page 130

OLE DB tends to be my default when I'm connecting to a SQL Server database. If
you do not fall into the category of using mostly components that use an ADO.NET
connection manager, and you do not fall into the category of having an organization
that wants to use a DSN, you will want to use an OLE DB connection manager.
You can fill out the property screen of the OLE DB connection manager as shown
in Figure 4-5 .
Figure 4-5 . OLE DB connection manager property screen
Creating a SQL Server Source Compon-
ent