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] access files methods modes packages segmenting SQL server storage SSIS server storage property expressions AcquireConnections method 2nd 3rd 4th ActiveX Data Objects (ADO) ActiveX Script Task adapters Data Flow Task destination 2nd creating DataReader Excel Flat File input buffer data ODBC OLEDB overview PreExecute method ProcessInput method properties RawFile Recordset ReinitializeMetaData method SQL Client SQL Server Flat File Destination Flat File Source OLEDB Source source 2nd AcquireConnections method creating Data Flow Task DataReader DtsPipelineComponent attribute Excel Flat File Flat File Destination JPG File EXIF Reader OLEDB ProvideComponentProperties method RawFile ReinitializeMetadata method ReleaseConnections method responsibilities runtime approach Validate method XML 2nd SQL Server Destination Add Existing Package command (SSIS Packages Node context menu) Add File Connection Manager dialog box Add Reference dialog box Add SSIS Connection Manager dialog box 2nd Add to SourceSafe Project dialog box adding attributes to custom components buffer rows connection manager properties data flow property expressions elements to packages feature properties Foreach loops forms Interop assembly references outputs rows scripts destination adapters Script Component transformations solutions to source control SSIS-specific properties/methods [See SSIS (SQL Server Integration Services).] tasks to BIDS designers variables additive transformations administrative threads ADO (ActiveX Data Objects) Connection Manager Enumerators ADO.NET Connection Manager configuring destination adapters advanced components Advanced Editor components, editing Data Flow components Data Flow Task Advanced tab (Connection Manager dialog box) AfterOpen task log event Agent subsystems Jobs creating credentials logins proxy accounts users paths permission problems Aggregate Transformation Editor Aggregate transforms 2nd All tab (Connection Manager dialog box) AllowConfigurationChanges property amount of data to process constraint amount of memory installed constraints Analysis Services Connection Manager applications [See utilities.] applying package configurations assemblies libraries Microsoft.Data.TransformationServices Microsoft.SQLServer.Dts.Design referencing task user interfaces AssignExpression (Assignment Expression) 2nd asterisks (*) asymmetrical checkins asynchronous outputs creating Data Flow Task execution trees asynchronous transforms attributes custom components DtsConnection DtsForEachEnumerator DtsLogProvider DtsPipelineComponent 2nd DtsTask EnableDisable EnableExpandable LocalizablePropertyCategory LocalizablePropertyDescription LocalizablePropertyName SortProperties task user interfaces EnableDisable EnableExpandable LocalizablePropertyCategory LocalizablePropertyDescription LocalizablePropertyName SortProperties transforms Audit Transformation Editor Audit transforms configuring profile auditing components auditing transforms Audit Percentage Sampling Row Sampling RowCount available memory constraint |