Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why odi creates data type datetime2(27) and because of it create table in sql server 2012 is failing

User_31EQJJan 13 2015 — edited Jan 13 2015

Hey

I got a situation here, i have flat file and i would like to load it into sql server 2012.

In the flatfile i have 2 columns datatypes as date and i have choosen LKM FILE TO SQL, when i try to run it is failing at create work table.

when i c the code of that step it shows

create table dev.dbo.C$_0TES

(

ASN_BOL_NBR NUMERIC(7,0) NULL,

ASN_CARTON NUMERIC(20,0) NULL,

ASN_SHORT_SKU NUMERIC(7,0) NULL,

ASN_SKU_CHECK_DIGIT NUMERIC(1,0) NULL,

ASN_DESC VARCHAR(25) NULL,

ASN_QUANTITY NUMERIC(7,0) NULL,

ASN_LEAVE_DATE DATETIME2(27) NULL,

ASN_ARRIVAL_DATE DATETIME2(27) NULL,

ASN_MULT_PACK VARCHAR(1) NULL,

ASN_MULT_SKU VARCHAR(1) NULL

)

Msg 1002, Level 15, State 1, Line 9

Line 9: Specified scale 27 is invalid.

Because of data type DATETIME2(27) the create work table is failing

ASN_LEAVE_DATE DATETIME2(27)

ASN_ARRIVAL_DATE DATETIME2(27)

Is there a way to avoid DATETIME2(27)?

Thanks!

This post has been answered by JeromeFr on Jan 13 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2015

Added on Jan 13 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

534 views