April 27, 2012 at 7:33 am
Our SSIS package data conversion task is copying SQL Server 2008 R2 data to an Oracle 11 database table AND is incorrectly converting the data values for 1 column.
Here are the attributes:
SOURCE:
SQL Server 2008 R2 sp1
COLUMN_1 numeric(6,0) not null
Data Value: 220490
SSIS Pkg Data Conversion:
string [DT-STR]
length 14
code page: 1252 (ANSI - Latin I)
TARGET:
Oracle 11
COLUMN_1 char (14 Byte)
Data Value: 220490 ED
any thoughts WHY the 'ED' is being appended? And suggestions on resolving this issue?
April 29, 2012 at 3:02 pm
Express12 (4/27/2012)
TARGET:Oracle 11
COLUMN_1 char (14 Byte)
Data Value: 220490 ED
Any particular reason to use CHAR data type - which is deprecated - instead of using a proper number data type on the Oracle side?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 30, 2012 at 4:48 am
Unfortunately, we cannot change the target Oracle legacy system. Wish we could.
Does SSIS have a data conversion rule that will accomodate this target data type?
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply