it doesnt work for me either!!!!

That's cool. I dont know what I was doing wrong but now the variable worked fine.

Also, a temp stored proc is a good idea as I cannot create a regular...

well, that is my problem... the variable accepts only 4k characters and the query component 8k. My query, however, goes over 4k, so I cannot use a variable.

Tks

OK, this works for a simple query. However, if you have a parameter on a subquery, it doesnt work...

That is my problem...

Ok... tks Don....

Now, I'm moving this question to SQL 2005 Integration Services to get SSIS answers.