When you create a excel source component in your data flow, you have to specify a connection manager for it (SSIS designer suggests to create one). When you create one...