What are the for each loop enumerators available in SSIS?

 

  • Below are the lists of various types of enumerators provided by SSIS Foreach Loop Container:
  • Foreach File Enumerator: It enumerates files in a folder. The plus point here is it can traverse through subfolders also.
  • Foreach Item Enumerator: It enumerates items in a collection. Like enumerating rows and columns in an Excel sheet.
  • Foreach ADO Enumerator: Useful for enumerating rows in tables.
  • Foreach ADO.NET Schema Rowset Enumerator: To enumerate through schema information about a data source. For example, to get list of tables in a database.
  • Foreach From Variable Enumerator: Used to enumerate through the object contained in a variable. (if the object is enumerable)
  • Foreach NodeList Enumerator: Used to enumerate the result set of an XML Path Language (XPath) expression.
  • Foreach SMO Enumerator: It enumerates through SQL Server Management Objects (SMO) objects.

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

How checkpoint works in for loop?

  For each Loop, the container is another atomic unit of work that can be restarted. However, the checkpoint file does not contain information about the work completed by the child containers, and the for each Loop container and its child containers run again when the package restarts.
Read more

What are the fast load options available in SSIS?

  The OLE DB Destination provides more than one way to load data in the destination (5 types of Data Access Mode).  Use Fast Load option while loading data into the destination. Data Access Mode  – It allows to define the method to upload data into the destination. The fast load option will use  BULK INSERT  statement instead of  INSERT  statement. If the fast load option is not selected then by default INSERT is used. Keep Identity  – If selected, the identity values of source are preserved and the same are uploaded into the destination table. Else destination table will create its own identity values if there is any column of identity type. Keep Nulls  – If selected, the null values of the source are preserved and are uploaded into the destination table. Else if any column has default constraint defined at destination table and NULL value is coming from the source for that column then in that case, default value will be inserted into the de...
Read more