Video on Memory Optimization for SSIS packages

Improving RAM Utilization within SSIS packages using data types. In this video we explore the impact of incorrect data types on how SSIS allocates RAM and the simple and easy fix to the problem.

This video demonstrates how using the incorrect datatypes causes SSIS to overestimate the amount of RAM needed and as a result causes the package to throw out of memory exception. We then go on to show how using the correct datatype helps SSIS overcome the issue.

https://www.youtube.com/watch?v=UlA48CGHtbE