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

Hands-On Microsoft SQL Server 2008 Integration Services part 20. 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. . | 168 Hands-On Microsoft SQL Server 2008 Integration Services If you have chosen ADO or Connection Manager in the ConnectionType field earlier the IsQueryStoredProcedure field becomes available for use and you will be able to specify that the SQL statement to be run is a stored procedure. When you select OLE DB Connection Manager in the ConnectionType field you can specify in the BypassPrepare field whether the task should skip preparing the query step before running it. When SQL queries are run the SQL statement is parsed and compiled in the first step and then executed based on the execution plan prepared earlier in the compilation step. By default the BypassPrepare field is set to True which means when the query is run the first time it parses and compiles the SQL statement in the first step and keeps the execution plan in the cache of the database engine and in the next step uses this execution plan to execute the query. So when the query is run the next time it doesn t parse and compile the statement but rather uses the existing execution plan saving time required to parse and compile. If you re running a query multiple times it is faster and efficient if you use a prepared execution however if you re running the query only once it is not a recommended option. Parameter Mapping Page If you are running a parameterized SQL statement you can map variables to the parameters in this page. The interface on this page is relatively simple and provides self-explanatory fields and options. You can click Add to add a parameter mapping and then click in each field to select the available values from the drop-down lists however in the Parameter Name field you have to type in a value. The configuration of this page has been covered in the Using System Variables to Create Custom Logs Hands-On exercise in Chapter 3. Result Set Page If you are using a query that will return a result set and you have selected a value other than None in the ResultSet field on the General .