hello, i have a excel sheet (excel 2003) and one of the column doesn't have value in all the rows. some of the rows have value and it is integer. when i use this sheet to import, in external column, it is showing data type as unicode string, i manually changed the data type of output column to different integer types but it doesn't shows any data. if i go back to excel sheet, change the numeric value into text (add quote next to number '999999 instead 99999) it shows me the value. what is the best method to work with this issue. one thing is for sure, if this column will have value that will be always integer. any help, thanks, p mark it as answer if it answered your question :)

hi, Use IMEX=1 in connection string to excel. it will convert eveything to string and you can use derrived column transformation to convert it to int in the pipeline. Regards OnurBI and ERP Senior Consultant @ Nexum Bogazici If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.