Configuring the code page of a OLEDB source.

hi,

i have a number of interfaces in which i have used oledb source.

the problem i am facing is oledb source components code page is not configurable now if i want to deploy the interface in a different environment which has a database with a different collation it gives a error that oledb source needs new metadata.

has anybody faced this problem earlier.please give me a solution to this problem ..

thanks in advance.

srikanth

Could you change the query to use cast around any varchar columns to force them the same or do you want to keep the collation for accents etc?

Try changing the AlwaysUseDefaultCodePage property to true?