tailieunhanh - Hands-On Microsoft SQL Server 2008 Integration Services part 42

Hands-On Microsoft SQL Server 2008 Integration Services part 42. 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. . | 388 Hands-On Microsoft SQL Server 2008 Integration Services In the Component Properties tab you specify common and custom properties for this component. The properties you can specify are The number of seconds before the command times out in the CommandTimeout field. By default this field has a value of 0 which indicates an infinite timeout value. The code page value in the DefaultCodePage field when the data source is unable to provide the code page information. The LocaleID which can be changed from the default value to any other Windows LocaleID. The ValidateExternalMetadata value which can be changed from the default value of True to False if you do not want your component to be validated during the validation phase. The SQLCommand field where you can type in the SQL statement that this transformation runs for each row of the input data. You can use parameters in your SQL statement and map these parameters to the input columns so that the SQL statement is modifying the data made available by OLE DB Connection Manager on the basis of values in the input columns. By default these parameters are named as Param_0 Param_1 and so forth and you cannot change these names. However if you use a stored procedure with sql variables in it then you can use the variable names that make the mappings of parameters easier. This option has been explained later in the chapter refer to Figure 10-9 . The mappings between parameters used in SQL statements and input columns are defined in the Column Mappings tab. In this tab after typing the SQL statement in the SQLCommand field you will see the Available Destination Columns populated with parameters for you. You may have to click Refresh to see the parameters. The automatic population of parameters is dependent on the ability of the OLE DB provider you ve specified earlier. For some third-party OLE DB providers that do not support deriving parameter information from the SQL statement you will need to manually create parameter columns