Is there a way except advanced editor to change the data type of all columns of excel source in one shot instead of doing for every columns one by one manually fron advanced editor.
You mention advanced editor. Are you using a flat file connection to point to the Excel file? I am wondering if this is actually a csv file that you opened with Excel. If so in the advanced editor you can select all the columns at once by using shift and the down arrow. then in the right pane change the data type to dt_str and it does it for all. If it is in Excel then I don't know any other way aside from the data conversion transformation.
----------------------------------------------------