When I parse the sql and active X all OK. When I execute the package the follow error is returned.
[INFORMIX][INFORMIX ODBC DRIVER]Wrong Number of Parameters
I've tried a few different ways of doing this and the error remains the same. I can't find anything helpful of the error message. I'm assuming that I'm overlooking something really obvious to those with more knowlege than me, because if this type of scenario is beyond the scope of DTS then what is the use of the feature?