Explain Sort Transformation?

 This component will sort data, similar in TSQL command ORDER BY. Some transformations need sorted data.

Comments

Post a Comment

Popular posts from this blog

What is SSIS Container? Explain Different types of Containers in SSIS

Image
SSIS containers are defined as a set of logically linked tasks that allows the management of the task scope effectively. Containers allow looping through tasks set until tasks are grouped logically or until specified criteria are met. Nesting of containers is also allowed and the containers are set in the Package designer section in the Control flow tab.   The following containers are present in SSIS: Task Host Containers:  Default container where all single tasks are available and are used for background scenes in SSIS. This is not present in the toolbox of Visual Studio and is assigned to the task implicitly. This container is also used to extend event handlers and variables. Sequence Containers:  These handle the flow of package subset and helps to divide packages into smaller pieces. These are displayed in the Control Flow tab. We can drag and drop containers from the toolbox in the design pane and then add a set of tasks into the container. Following things can be ac...
Read more

What are import and export column transformations?

Import Column Transformation  – The Import Column transformation reads data from files and adds the data to columns in a data flow. Using this transformation, a package can add text and images stored in separate files to a data flow. * Export Column Transformation  – The Export Column transformation reads data in a data flow and inserts the data into a file. *
Read more

What is the property “RunInOptimized”? How to set this property?

  If this property is set to true then the SSIS engine ignore the unused/unmapped columns. Means it does not allocate memory to store data for those columns. At the compilation phase itself SSIS engine identifies what are the columns from source are using across the package, if it finds any columns are neither using nor mapping to destination, it simply ignores all those columns. We can set this property at two levels “Project Level” and “Package Level”. Project Level: From project properties → Debugging → RunIn*****. By default “FALSE” Package Level: Can find in DataFlow properties. By default “TRUE”
Read more