Thank you for the explanation.

It is crystal clear to me, now. 😀

Hi Erik,

You know I suppose to use 2GB of process, right?

When I look into the task manager, I don't see anything that's using close to it while SSIS package was...

thanks for the linky.

😀

it go beyond 4GB on my win2003 32bit ent.

thanks becklery, bubberz, and Siva. i like options. 😀

so, i like each of your different, yet, helpful solution.

thanks! that works wonderfully.

the table is now matrix, how to do the same thing for matrix?

thanks for your idea.

would you have an example of using NOTHING as keyword for tsql in a store proc?

assigning NOTHING in VB or C# is fine, but, how...