hi all, i have a question its regarding dts.i am trying to import the excel file,the problem is in one particular column the data is left justifiedand right justified, with character data left justified and numeric data right justified.when i am importing using it dts designer it is only importing character data it is not importingnumeric data. is there a way to import the data from excel so that it imports both characterand numeric data.please throw ideaslara
