RunInOptimizedMode properties in SSIS

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 the source are using across the package, if it finds any columns are neither using nor mapping to the destination, it simply ignores all those columns.

We can set this property at two levels “Project Level” and “Package Level”.

Project Level:

Right click on the project properties → Debugging → RunInOptimizedMode.

  

   

By default “FALSE”

Now we need to set it true.

  

Package Level:

We can find it in Dataflow properties. See below.

  

 By default “TRUE”