Exploring the SSIS Environment in More Detail
The first section of this chapter gave a quick overview of some basic elements of SSIS. The following section offers a more complete guide to the features of SSIS.
Using Connection Managers
Recall that a connection manager is a wrapper for the connection string and properties required to make a connection at run time. The following sections represent types available and configuration options to consider
Using Database Connection Managers
Defining database connections through one of the available connection managers requires setting a few key properties:
- Provider: The driver to be used in accessing the database
- Server: The server or filename containing the database to be accessed
- Initial Catalog: The default database in a multidatabase source
- Security: Database authentication method and any username/password ...