blom0344 wrote:Passing the parameter is the cause of the delay it seems. Hard-coding provides the best response sofar, so I'm going to implement that solution.
Did you try using a variable for the source so that a hard coded query is presented to the source, but it is first determined by SSIS? Or does this crash too? You can start out without using the date variable, just hard code the query inside double quotes in the variable's expression property, then if that works add the date variable to the expression.