Hands-On Microsoft SQL Server 2008 Integration Services part 9. 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. . | 58 Hands-On Microsoft SQL Server 2008 Integration Services in the Data Flow Sources section and the OLE DB Destination appears in the Data Flow Destinations section. There are several transformations components listed in the Data Flow Transformations section though none is used here. This simple package shows a typical example of a data flow that contains a Data Flow Source and a Data Flow Destination. Finally the Data Flow Destination Destination RawDataTxt is an OLE DB destination that loads the converted records to the RawDataTxt table in the Campaign database. 10. The data flow components of an Integration Services package expose their properties in a custom user interface that is built for most of the components or in the Advanced Editor that is common to all the components. Some of the components do not have a custom user interface so they use only the Advanced Editor to expose their properties and attributes. Sometimes you may have to use the Advanced Editor even though the component has a custom UI as some components do not expose all the properties in the custom UI. You can open the custom user interface by choosing the Edit command from the component s context menu and the Advanced Editor using the Show Advanced Editor command. Right-click the Source RawDataTxt_csv object and choose Show Advanced Editor from the context menu. 11. You will see four tabs in the Advanced Editor. The Connection Managers tab specifies SourceConnectionFlatFile connection manager that this component uses to connect to the flat file. The Connection Manager field here displays all the connection managers defined in the package. 12. Move on to the Component Properties tab. Here you will see the Common Properties that specify properties such as Name and Description and Custom Properties sections. 13. Click the Column Mappings tab. In the upper half of this tab you can see the columns mapped by the mapping lines and the lower half lists these mapped external columns .
