Browse by Tags

Tagged Content List
  • Wiki Page: SSIS: List of Transformations

    When it comes to data processing, Integration Services reads data from various sources, and writes them to their destinations, but usually some transformation of the data is needed in the meantime (according to the requirements, of course). SSIS can transform the data using its own transformation components...
  • Wiki Page: SSIS Lookup Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Lookup is a fairly popular transformation. Its reason is that using...
  • Wiki Page: SSIS Aggregate Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . In a BI environment, data consumers might not be interested...
  • Wiki Page: SSIS Multicast Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the data flow must be processed in a detailed and an aggregated way, or different...
  • Wiki Page: SSIS Conditional Split Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Conditional Split transformation is a fairly simple one: based on the condition set defined...
  • Wiki Page: SSIS Sort Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. The Sort transformation basically has only one task: to put the incoming rows in a specified...
  • Wiki Page: SSIS Merge Join Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . Combining data from separate sources is quite often...
  • Wiki Page: SSIS Pivot Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . There are many cases (for example, in reporting), when some...
  • Wiki Page: SSIS Pivot transzformáció (hu-HU)

    Az ETL adatfolyamokban az Integration Services transzformációkat használ az adatok manipulálására. A transzformációkat a Data Flow Task-okban használhatjuk, adatforrás- és célkomponensek, illetve más transzformációk...
  • Wiki Page: SSIS Audit Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . In some cases the ETL process is required to be audited. This means that data must contain...
  • Wiki Page: SSIS Percentage Sampling Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the source data has large volumes, and during development, less rows would be...
  • Wiki Page: SSIS OLE DB Command Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Creating data-driven ETL process es is not unusual during a data warehouse implementation...
  • Wiki Page: SSIS Row Sampling Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the source data has large volumes, and during development, less rows would be...
  • Wiki Page: SSIS Character Map Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Alphanumeric values are often need transformation during a data flow: converting to upper...
  • Wiki Page: SSIS Merge Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes sorted data flows can be a key requirement, especially before joining data with...
  • Wiki Page: SSIS Script Component Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . ETL developers sometimes face requirements which cannot be solved with the built-in transformations...
  • Wiki Page: SSIS Derived Column Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Data usually must be transferred after replacing the values in some columns, or a new,...
  • Wiki Page: SSIS Row Count Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. The Row Count transformation simply counts the records flowing through a data path. It only...
  • Wiki Page: SSIS Union All Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. There are situations when data from multiple but similar sources must be combined into a...
  • Wiki Page: SSIS Unpivot Transformation

    Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Unpivot transformation can help in normalizing of a dataset during the load process of...
Page 1 of 1 (20 items)
Can't find it? Write it!