Yes I have tried moving the predicate to the join and had the same result.

You could also try creating a script task and writing C# or VB code to connect to the DB and execute the command. Not sure if the limitation would apply...

Thanks for the info. I will probably end up just creating a separate table on another filegroup and move data with an SSIS package to accomplish. I was just tinkering...