I have inherited a corrupt SSIS package. It is unclear what is corrupt about it. I have build a new solution with a new SSIS project. Imported the corrupt .dtsx into the new project along with project.params and .connmgr files. Now I can open the .dtsx but it gives me errors on the connections. (Expected). In the .dtsx I replaced the values of the old ConnectionManagerID's with the new values found in the project.params. This works like a charm. Only the dataflows are giving me a headache. They have now the proper connection. All of them are using 'Table or view' as the 'Data access mode' but the 'Name of the table or view' is empty. The names of the OLE DB Source components are sufficiently vague that it is not apparent which table or view should be entered into the 'Name of the table or view'. Can I somehow retrieve this information from the original .dtsx ?
Somehow this package was really really old, upgrading through all the BIDS/VS versions since 2008 made it readable.