1163
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
FIGURE 52-6
Flat File Connection Manager Editor.To create the Adventureworks Database destination along with its Connection Manager,
execute the following steps:- Double-click the Destination Assistant.
- Select SQL Server, and click OK. The Ole DB connection manager editor appears.
- Confi gure it as shown in Figure 52-7, where JASHP is the name of your SQL Server.
- Click OK.
Although OLEDB is still the default connection type that SSIS uses when SQL Server is selected from the Destination
Assistant, it should be noted that Microsoft intends to deprecate OLEDB in the future. ODBC is now the preferred
connection type for SQL Server. There is now an ODBC Source and Destination available inside the SSIS Data Flow.
For more information, see “Microsoft is Aligning with ODBC for Native Relational Data Access” at http://blogs
.msdn.com/b/sqlnativeclient/archive/2011/08/29/
microsoft-is-aligning-with-odbc-for-native-relational-data-access.aspx.c52.indd 1163c52.indd 1163 7/31/2012 10:29:26 AM7/31/2012 10:29:26 AM
http://www.it-ebooks.info