CODEWITHSUNDEEP
memoryssis
Kate
Kate

Reputation: 455

Does SSIS run on memory doing transformation or does it store anywhrere?

I have Flat file input and my output will be flat file too. I want to know when we do transformation using flat file to flat file , does data get stored in anywhere on back end of SSIS or does it only runs on the memory on run-time?

Upvotes: 0

Views: 122

Answers (1)

billinkc
billinkc

Reputation: 61231

It depends.

As a general rule, SSIS is an in memory ETL tool. That's how it provides the high throughput by never touching disk.

Situations where it will spill to disk are when the system is under memory pressure. That can be through external factors (too many competing processes on the box), self-inflicted factors (semi/blocking transformations, too many operations running in parallel), and/or "fat" data types (binary/max/LOB) in your data flows.

You can watch performance counters for ... buffers spooled/spilled something like that and if that's non-zero, then you're dumping intermediary files to disk.

Upvotes: 1

Related Questions