March 20, 2009 at 2:16 am
Why are you converting it to a string just to convert it back to an int?
What do you mean?
The SOURCES table stores the run_date as INT
In the destination table I have set the RUN_DATE to be DATE.
March 20, 2009 at 3:38 am
what is the error you getting?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 20, 2009 at 3:59 am
What im doing in the SSIS:
Run_Date(INT) --DataConversion--> Run_Date(DT_STR) --DataConversion--> Run_Date(DT_Date) --INSERT INTO TABLE--> FAILS
Error:
It fails on the last DataConversion, with the error:
Error: 0xC02020C5 at Dealbook Job History, Data Conversion 1 [1320]:
Data conversion failed while converting column "run_date STRING" (1334) to
column "run_date DATE" (1344). The conversion returned status value 2 and
status text "The value could not be converted because of a potential loss of
data.".
Error: 0xC0209029 at Dealbook Job History, Data Conversion 1 [1320]: SSIS
Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output
column "run_date DATE" (1344)" failed because error code 0xC020907F
occurred, and the error row disposition on "output column "run_date DATE"
(1344)" specifies failure on error. An error occurred on the specified object of
the specified component.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply