Error - Data Flow - System.Exception: Memory is locked - Random Error due to multicast and Large String (DT_TEXT blob type)

Introduction

Sometimes if you use MultiCast / Conditional Split or any component which produces multiple outputs in SSIS Data Flow you may get the following error.

Error: System.Exception: Memory is locked.

Possible Cause

When you have Blob datatype (i.e. DT_TEXT, DT_NTEXT, DT_IMAGE) in one or more columns and it's being multi-cast into multiple flows in such a situation this error can happen.

Possible Solution

When this error happens we recommend you reduce the number of parallel flows. The best thing is to remove multicast and use multiple flows like below.

From below (Old way)

Change to  (New way)

An alternate way to the above is to create 3 data flows and place them in a sequence container or connect them in sequence if you ok to process them one by one.

Contact Us

If you have more question(s) feel free to contact us viaLive chator email [e-mail]

https://zappysys.com/support/