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

you install the providers, you can uncheck the Show Only Installed Source Types op-
tion. By only offering the one SQL Server choice, Integration Services is making your
life easier by directing you to the correct provider immediately. When you select the
Source Assistant's SQL Server type, it will use the OLE DB connection manager,
which is also your go-to connection manager!
Once you select the SQL Server type, you have the option of selecting an existing
connection manager from the pane on the right or creating a new one. Creating a new
connection manager will take you through the exact steps you looked at previously for
setting up an OLE DB connection manager.
Finally, pick your new or existing connection manager and click the OK button.
This will create the connection manager and add the SQL Server source to the Data
Flow task. You can then immediately pick up your development by creating and optim-
izing the SQL query. The Source Assistant is a great way to get started with developing
your Integration Services package, especially if you are new to Integration Services. If
you know that you want to use one of the other types of connections, you can just cre-
ate the connection manager and source directly, without having to use the Source
Assistant. Either way, you have a few ways to start your development as quickly as
possible.
Summary
At this point, we described why you would want to use certain SQL Server sources
over others, how to set up the source, and how to clean up the source query to get the
best performance out of your package. We also covered sources in general to set up the
rest of the source chapters.
Although all of the principles described in this chapter are patterns for SQL Server,
you can apply many of them to other source types as well. Be sure to review the rest of
the source chapters for patterns that you can use for SQL Server in addition to what we
have already discussed.