I tried this with my actual query and the output file was correct. I then switched back to using my variable and received an error. The objects and characteristics of the columns are not available any more.

I am using VS2008