you can set IMEX=1 in the excel connection manager's connectionString property like below: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"http://www.rad.pasfu.com

Hi... I have a excel file with employeeId's Emloyee_ID: 500005320 SMN00019 so i wanted to populate the data with integer into SQL DB and the string to Flat File... Can someone help me in resolving the issue.

Hi, Its better to see this earlier thread . SSIS Redirect Non Interger Data

here the datatype is DT_R8 which is a float comming from the excel

you can set IMEX=1 in the excel connection manager's connectionString property like below: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"http://www.rad.pasfu.com

you can copy two rows with string values in this column to top of excel rows, then excel jet engine will consider the column as stringhttp://www.rad.pasfu.com

Thanks alot its working now...........