Hands-On Microsoft SQL Server 2008 Integration Services part 38. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 348 Hands-On Microsoft SQL Server 2008 Integration Services Figure 9-5 Flat File Advanced Editor showing FastParse and UseBinaryFormat properties OLE DB Source You will be using an OLE DB source whenever you need to extract data from a relational database that is OLE DB-compliant such as Microsoft SQL Server an Oracle database server IBM s DB2 database server an Access database or even an Excel file. An OLE DB provider is used in an OLE DB Connection Manager to Chapter 9 Data Flow Components 349 connect to the database and an OLE DB source uses the OLE DB Connection Manager to bring the data into the data flow. Just to remind you here that if you use an Integration Services Data Source inside an OLE DB Connection Manager you can actually make Data Source or Data Source view available through the OLE DB Connection Manager to all of your projects within an Integration Services project. Not all OLE DB providers are the same you should check the documentation of the OLE DB provider that you want to use in your package as some limitations are associated with different types of OLE DB providers. The OLE DB source has one regular output and one error output. This data flow component has a custom user interface that is similar to the Excel source adapter discussed earlier and its properties can also be configured using the Advanced Editor. When you open an OLE DB Source Editor it takes you into the Connection Manager page. Here you can specify an OLE DB Connection Manager from the drop-down list provided in the OLE DB Connection Manager field. The OLE DB Source provides you the following four levels of data access mode options Table Or View Specify the name of the table or the view from which you want to extract data. Table Name Or View Name Variable Specify the variable name which will be the holding name of the table or the view. SQL Command Write an SQL statement to extract data. You have the option of using a parameterized SQL query here. SQL Command From Variable .
