Source : XML (string)
Staging : SQL table (nvarchar)
Target : Flat file (437 code page)
I consume an XML source and load it into SQL table .
Then trying to load the flat file from SQL table after applying required transformations.
Select Name, '' as age from Tablename;
// selecting from staging table;
Here, I am not able to convert Age from DT_STR from code page 1252 to 437,,,it says it is not supported.
Name is unicode string and hence am able to convert to 437 code page.
Can anybody help