SSIS Error while executing data flow task - import excel into sql table

Question

I have created ssis package that is taking data from excel file and insert data into table I have one Excel Source and Ole db connection

but i'm getting following errors:

    [Excel Source [1]] Error: There was an error with output column "F2" (18) on     
    output "Excel Source Output" (9). The column status returned was: "The value could 
    not be  converted because of a potential loss of data.".


    [Excel Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. 
    The "output column "F2" (18)" failed because error code 0xC0209072 occurred, and  
    the error row disposition on "output column "F2" (18)" 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.


    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput 
    method on component "Excel Source" (1) returned error code 0xC0209029.  The 
    component returned a failure code when the pipeline engine called PrimeOutput().  
    The meaning of the failure code is defined by the component, but the error is 
    fatal and the pipeline stopped executing.  There may be error messages posted 
    before this with more information about the failure.

`

Widor Widor · Accepted Answer · 2011-09-20T10:20:32

The line:

The value could not be  converted because of a potential loss of data

Suggests that you have a field such as a string that may be longer than the SQL table field. E.g. you have a 60-character string that you're trying to insert into a Varchar(50) field?

Or perhaps a decimal number into an Int or similar?

Check your datatypes match, in other words.

SSIS Error while executing data flow task - import excel into sql table

4 Answers