Overview Data in Data Flows Integration Services Data Types Parsing Data Comparing String Data Add or Delete a Component in a Data Flow Set the Properties of a Data Flow Component Connect Components in a Data Flow Integration Services Paths Resolve Column Reference Editor Data Viewer Error Handling in Data Data Flow Performance Features Source Assistant Destination Assistant ADO NET Source ADO NET Source Editor (Connection Manager Page) ADO NET Source Editor (Columns Page) ADO NET Source Editor (Error Output Page) ADO NET Destination ADO NET Destination Editor (Connection Manager Page) ADO NET Destination Editor (Mappings Page) ADO NET Destination Editor (Error Output Page) ADO NET Custom Properties Azure Blob Source Azure Blob Destination Azure Data Lake Store Source Azure Data Lake Store Destination CDC Flow Components CDC Source CDC Source Editor (Connection Manager Page) CDC Source Editor (Columns Page) CDC Source Editor (Error Output Page) CDC Source Custom Properties Extract Change Data Using the CDC Source CDC Splitter Direct the CDC Stream According to the Type of Change Define a State Variable Data Mining Model Training Destination Data Mining Model Training Editor (Connection Tab) Data Mining Model Training Editor (Columns Tab) Data Mining Model Training Destination Custom Properties Data Streaming Destination Configure Data Streaming Destination Walkthrough: Publish an SSIS Package as a SQL View DataReader Destination DataReader Destination Custom Properties Dimension Processing Destination Dimension Processing Destination Editor (Connection Manager Page) Dimension Processing Destination Editor (Mappings Page) Dimension Processing Destination Editor (Advanced Page) Dimension Processing Destination Custom Properies Excel Source Excel Source Editor (Connection Manager Page) Excel Source Editor (Columns Page) Excel Source Editor (Error Output Page) Excel Destination Excel Destination Editor (Connection Manager Page) Excel Destination Editor (Mappings Page) Excel Destination Editor (Error Output Page) Excel Custom Properties Flat File Source Flat File Source Editor (Connection Manager Page) Flat File Source Editor (Columns Page) Flat File Source Editor (Error Output Page) Flat File Destination Flat File Destination Editor (Connection Manager Page) Flat File Destination Editor (Mappings Page) HDFS File Source HDFS File Destination Flat File Custom Properties OData Source Tutorial: Using the OData Source Modify OData Source Query at Runtime OData Source Editor (Connection Page) OData Source Editor (Columns Page) OData Source Editor (Error Output Page) OData Source Properties ODBC Flow Components ODBC Destination ODBC Destination Editor (Error Output Page) ODBC Destination Editor (Mappings Page) ODBC Destination Editor (Connection Manager Page) Load Data by Using the ODBC Destination ODBC Destination Custom Properties ODBC Source ODBC Source Editor (Error Output Page) ODBC Source Editor (Columns Page) ODBC Source Editor (Connection Manager Page) Extract Data by Using the ODBC Source ODBC Source Custom Properties OLE DB Source Map Query Parameters to Variables in a Data Flow Component OLE DB Source Editor (Connection Manager Page) OLE DB Source Editor (Columns Page) OLE DB Source Editor (Error Output Page) Extract Data by Using the OLE DB Source OLE DB Destination OLE DB Destination Editor (Connection Manager Page) OLE DB Destination Editor (Mappings Page) OLE DB Destination Editor (Error Output Page) Load Data by Using the OLE DB Destination OLE DB Custom Properties Partition Processing Destination Partition Processing Destination Editor (Connection Manager Page) Partition Processing Destination Editor (Mappings Page) Partition Processing Destination Editor (Advanced Page) Partition Processing Destination Custom Properties Raw File Source Raw File Source Editor (Connection Manager Page) Raw File Source Editor (Columns Page) Raw File Destination Raw File Destination Editor (Connection Manager Page) Raw File Destination Editor (Columns Page) Raw File Custom Properties Recordset Destination Use a Recordset Destination Recordset Destination Custom Properties SAP BW Source SAP BW Source Editor (Connection Manager Page) SAP BW Source Editor (Columns Page) SAP BW Source Editor (Error Output Page) SAP BW Source Editor (Advanced Page) Look Up RFC Destination Look Up Process Chain Request Log Preview SAP BW Destination SAP BW Destination Editor (Connection Manager Page) SAP BW Destination Editor (Mappings Page) SAP BW Destination Editor (Error Output Page) SAP BW Destination Editor (Advanced Page) Look Up InfoPackage Create New InfoObject Create InfoCube for Transaction Data Look Up InfoObject Create InfoSource Create InfoSource for Transaction Data Create InfoSource for Master Data Create InfoPackage SQL Server Compact Edition Destination SQL Server Compact Edition Destination Custom Properties SQL Server Destination SQL Destination Editor (Connection Manager Page) SQL Destination Editor (Mappings Page) SQL Destination Editor (Advanced Page) Bulk Load Data by Using the SQL Server Destination SQL Server Destination Custom Properties Transformations XML Source XML Source Editor (Connection Manager Page) XML Source Editor (Columns Page) XML Source Editor (Error Output Page) Extract Data by Using the XML Source XML Source Custom Properties