comma seperated qouted job parameter

[dsdoubt]

Iam passing values such as '234234','3453453','45645645' to a varchar field in ODBC stage as follows in the Where clause

Code: Select all

column1 in #Jobparameter#

Its giving wierd erros, sometime core dump.

If i pass the value as '23423' (single value), it works.
If I pass multiple integer value 23423,456456,56756 it works.

Kindly help me out.

[dsdoubt]

I can add escape character only for one value
eg: /'23423423/'

And not as

Code: Select all

 /'23423/',/'23423/'  Or /'234234/'/,/'234234/'

[chulett]

Your slashes are going the wrong way.