rodeomount
Programmer
I need to use a parameter to pass in one string with multiple values for use inside the "IN" filter of a select statement. Example: parameter is named myParam
I want to set myParam value to 'A2fg','A2fh','A2fi','A2fj'
And use it in the select statement inside the source query of a dts package like this
Select * from tblTable where ID in (?)
I've tried it but keep getting an error when clicking on preview that states:
[Microsoft][ODBC Driver For Oracle]Wrong Number of Parameters.
I want to set myParam value to 'A2fg','A2fh','A2fi','A2fj'
And use it in the select statement inside the source query of a dts package like this
Select * from tblTable where ID in (?)
I've tried it but keep getting an error when clicking on preview that states:
[Microsoft][ODBC Driver For Oracle]Wrong Number of Parameters.