(Warning: SSIS expert, SalesForce Noob)
I'm working an SSIS package where the source is Salesforce.com and every character field is being interpreted by SSIS as a Unicode nvarchar, which is designed for a lot of foreign languages and takes two bytes per character. Non-Unicode varchar's take only one byte per character and works fine with US-English.
Since the data is all for clients in US-Ohio I'll assume for the moment that varchar would work fine.
Question: Is there a SOQL data type for non-Unicode characters that I can use in my SOQL statements to pull data, so that SSIS will interpret the columns as non-Unicode and not Unicode?
Thanks in advance. Jim