As an update to this if anyone else comes across a similar issue. I managed to get the With statement running along with the parameter by using SQL command from...

Thanks for the reply Todd.

I was simply putting the where clause before the final ; in the listing above.

This was the only sub select in all the packages so...

Hi

Just as a follow up to this I found out what the issue was, this may have been the initial reply but was lost in translation from nerd...

Thank you both for taking the time to reply.

I can confirm the following:

1. Connection manager pointing to 2008 instance of SQL

2. I am using 2008 version of BIDS

I didn't really...