Clob in Oracle convert into Varchar (max)
-
I am using SSIS for SQl server 2014, try to import a column data type Clob into SQL server varchar(max).
It seems SSIS thinks it is a Unicode text stream [DT_NText]What should I convert it to in SSIS.
Thanks,
- sqlfriends - Thursday, September 28, 2017 4:56 PM
Do you know how many characters are actually in that column on Oracle? Basically, you want the MAX value of the LEN of that column. If it's more than 8,000, you might have to get creative. If it's less, then you can use OPENQUERY as part of the SQL that selects data from the Oracle table, and use CONVERT on the column in question, and to varchar(8000), which you can then certainly choose to map to a varchar(max) data type in your SQL Server table. However, if it's more than 8,000, then you need to know just how many characters is the maximum length of that field, cause it could get ugly...
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy) -
It is less than 4000.
I will have to use it in SSIS, OLEDB Oracle driver. try to avoid openquery.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply