how to make ssis map columns based order instead of column names <p>I am working on a project where there are <code>700</code> columns in a remote server and our destination table have columns that starts with underscore for example if there is a <code>"SchoolName"</code> column in the remote server, on our destination table we would have <code>"_SchoolName"</code> or <code>"_School_Name"</code> column. We use to use DTS package to import data "which doesn't use column name to map, instead it uses the order of the column on the select statement to map the column in the destination table". Now we would like upgrading our DTS package to SSIS, but mapping <code>700</code> columns manually has been a nightmare. Is there any way we can map columns based on the column orders instead of column name?</p>