Microsoft SQL Server 2005 Integration Services
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] Object Explorer (Management Studio) objects ComponentMetaData database Dts connections collection ExecutionValue property IDTSComponentEvents interface Log method Logging method TaskResult value transaction object variables packages storing Transaction values Obviex website ODBC Connection Manager ODBC Connection Manager dialog box ODBC destination adapter OLEDB Command transform configuring profile OLEDB Connection Manager 2nd OLEDB Connection Manager dialog box OLEDB Destination Adapter OLEDB Source Adapter 2nd OLEDB Sources OLEDBjn OnError log event OnExecStatusChanged log event OnInformation log event OnPostExecute log event OnPostValidate log event OnPreExecute log event OnPreValidate log event OnProgress log event OnQueryCancel log event OnTaskFailed log event OnVariableValueChanged log event OnWarning log event opening solutions Windows Event Viewer OperatingSystem class Operation property Operation task log event optimizing data flow 64-bit platform asynchronous transforms buffers, decreasing error handling fast drives, pointing to indexes internal IO transforms lookup reference data lookup/aggregate/sort transforms match indexes memory-intensive applications memory-intensive transforms operations, eliminating parallel execution partial/full cache mode row-intensive operations set-based operations Theory of Constraints queries sources Options dialog box Options dialog box (Visual Studio) order of data constraint organizing package configurations other software running on the same machine constraint out of process (Execute Package Task) outer variables Output window outputIDs parameter outputs adding source adapters asynchronous creating Data Flow Task execution trees buffer references columns component Data Flow Task error components Data Flow Task paths staging synchronous outputs parameter (PrimeOutput method) overriding package configurations |