March 10, 2006 at 7:52 am
Had a question I was hoping someone could help with. I have a Data Flow Transformation task where I am trying to pull data from Oracle RDB and am having problems. The data is coming in as Unicode String and I have tried using data conversion control to transform to non-Unicode string, but I am still getting truncation error every time I run the package.
I am pulling a string of 10 characters and trying to put in varchar column in SQL Server. I have tried changing the length in the conversion control to 1500 or higher and change the size of the column in the db, but I still get the truncation error.
Am I missing something stupid here? Any help would be appreciated.
March 10, 2006 at 5:14 pm
You are aware that SQL Server has nvarchar type for UCS-2 Unicode, but you're using varchar -- which means a specific codepage? Could your source data be outside the specific codepage you chose for your transformation?
March 13, 2006 at 9:57 am
Forgive me, but I am not sure what you are asking. Are you saying I could just change the destination table to nvarchar? I am trying to get away from having to change my table datatypes.
I am also not sure how to chage what codepage is being used when you have to use an ODBC connection and datareader source control in the transformation. Is there a way to find the codepage that applies to a particular provider?
Thanks for your help!
-Erich
March 13, 2006 at 4:09 pm
I also tried changing the field in the destination table to 1500 length nvarchar and am still getting the truncation error. I am not sure what the issue could be here.
I have setup the ODBC Connection Connection Manager(I am trying to connect to Oracle RDB) and assigned a DataReader Source to it. I have also tried to use the Import/Export wizard and copy how that would pull in the data, but I can't get the ODBC Connection to work. I keep getting error Cannot Get the Supported types from the Database Connection.
Any help would be great, I am stumped on this one.
Thank You,
Erich
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply