DSXchange

Posted: **Thu Sep 24, 2009 6:55 am**

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.

Posted: **Thu Sep 24, 2009 7:02 am**

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

And not as

Code: Select all

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

Posted: **Thu Sep 24, 2009 7:44 am**

Your slashes are going the wrong way.

DSXchange

comma seperated qouted job parameter

comma seperated qouted job parameter