July 29, 2010 at 12:57 pm
I have an Excel sheet with all general formatted Cells. (Excel 2007). Column C,D and E displays a date (e.g. 14.06.2010)
The dataconversion works fine if I convert Data to date.
The SSIS works also fine.
As soon as someone changes the data in Excel which shows like a date (e.g. 15.06.2010) in a cell, the format of this cell changes automatically to date.
After the file is saved an I try to run SSIS, SSIS comes up with the following error:
[Data Conversion [1943]] Error: Data conversion failed
while converting column "Erstellungsdatum" (688) to column "Copy of Erstellungsdatum" (2616).
The conversion returned status value 2 and status text
"The value could not be converted because of a potential loss of data.".
Can someone give me a hint, how to solve the problem either in Excel (no automatic changes from general to date)
or in SSIS (Input dateformat or general in the same column)?
Chaepp
July 29, 2010 at 1:27 pm
Did u try to see the values in SSIS using data viewer in between source and conversion Task.. Try to see what value is coming in from Excel and please also post the Complete error
July 29, 2010 at 10:54 pm
Hello divyanth
When the Excel-input of (21.06.2010) is in Format general then I'll see 21.06.2010 in the viewer.
As soon as I change the Date to 15.06.2010 in Excel, the Format changes to data in Excel an I'll see 40344 in the viewer as Excel Source Output.
The complete Error-Description from Progress is:
[Data Conversion [1943]] Error: Data conversion failed while converting column "Erstellungsdatum" (688)
to column "Copy of Erstellungsdatum" (2616).
The conversion returned status value 2 and status text
"The value could not be converted because of a potential loss of data.".
[Data Conversion [1943]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "output column "Copy of Erstellungsdatum" (2616)" failed because error code 0xC020907F occurred,
and the error row disposition on "output column "Copy of Erstellungsdatum" (2616)"
specifies failure on error. An error occurred on the specified object of the specified component.
There may be error messages posted before this with more information about the failure.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "Data Conversion" (1943) failed with error code 0xC0209029.
The identified component returned an error from the ProcessInput method. The error is specific to the component,
but the error is fatal and will cause the Data Flow task to stop running.
There may be error messages posted before this with more information about the failure.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED.
Thread "WorkThread0" has exited with error code 0xC0209029.
There may be error messages posted before this with more information on why the thread has exited.
July 30, 2010 at 7:55 am
I would suggest you to bring the values in as Varchar and convert them into Date using the Convert Task.. Also, change IMEX= 1 in the excel properties.. so that it gets the values as is without interpreting the Datatype based on top few columns..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply