Page 1 of 1
insert to sqlserver
Posted: Thu Apr 10, 2008 2:06 am
by ratna
Dear all,
i have a problem here.
i made a job..
oracle stage - transformer - Dynamic RDBMS
all i want to do is transfer the data from oracle to sqlserver.. but i dont know why, the data inserted to sqlserver always truncated..
like : 'John' will become 'Joh'
I put a peek stage before the Dynamic RDBMS stage, and the data in the peek stage were fine (not truncated).
Anybody know whats wrong?
Thanks
Posted: Thu Apr 10, 2008 9:01 am
by kausmone
Ratna,
Can you give more details please? Is this happening for all columns or for only one particular column etc? I am assuming that you have already checked and confirmed that the datatype of the source (Oracle) and the target (SQL Server) is the same for the column(s) that are showing this behavior...
-kaus
Re: insert to sqlserver
Posted: Thu Apr 10, 2008 9:33 am
by Ultramundane
ratna wrote:Dear all,
i have a problem here.
i made a job..
oracle stage - transformer - Dynamic RDBMS
all i want to do is transfer the data from oracle to sqlserver.. but i dont know why, the data inserted to sqlserver always truncated..
like : 'John' will become 'Joh'
I put a peek stage before the Dynamic RDBMS stage, and the data in the peek stage were fine (not truncated).
Anybody know whats wrong?
Thanks
We encountered a similar issue in 7.5.1 and 7.5.2 which was resolved via Ecase 74157
Re: insert to sqlserver
Posted: Thu Apr 10, 2008 9:34 am
by Ultramundane
ratna wrote:Dear all,
i have a problem here.
i made a job..
oracle stage - transformer - Dynamic RDBMS
all i want to do is transfer the data from oracle to sqlserver.. but i dont know why, the data inserted to sqlserver always truncated..
like : 'John' will become 'Joh'
I put a peek stage before the Dynamic RDBMS stage, and the data in the peek stage were fine (not truncated).
Anybody know whats wrong?
Thanks
We encountered a similar issue in 7.5.1 and 7.5.2 which was resolved via Ecase 74157
Posted: Thu Apr 10, 2008 10:26 pm
by ratna
kausmone, this happened to every column.. and yes, datatype of the source and the target column are the same..
And Ultramundane, i dont understand.. what is Ecase 74157?
Thanks all for replying...
Posted: Sun Apr 13, 2008 5:10 pm
by Ultramundane
ratna wrote:kausmone, this happened to every column.. and yes, datatype of the source and the target column are the same..
And Ultramundane, i dont understand.. what is Ecase 74157?
Thanks all for replying...
Ecase 74157 references a bug fix created by IBM. If you would like to get the fix from IBM you should contact them and request the fix.