Hi All, I'm using SSIS 2005. I have declared a package Level Variable of type object. within one of my dataflows I populate the variable with a dataset. I then use this in another dataflow as an input to another transformation. At this point I have finished with the data and would like to remove the contents of the variable from memory to help stop OutOfMemory error's. How can I clear the contents of the variable?

I suspect the best, possibly only, way is to write something else (e.g. an empty dataset) into that variable. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me