Thanks. I tend to use stored procedures but usually not for these things (SSIS packages). I did try it though; combined the two parts and made a stored proc. It...

I ran into the same problem. Stand-alone query produced results but when put into a Data Flow task, the target flat file came up empty. Nothing I did with in...