I am doing accordingly per your inputs I get these below errors:
Error at SSISPackage [Connection manager "Sale Excel Source"]: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
Error at SSISPackage: The result of the expression "@[User::varFilePath]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
Error at Data Flow Task [Sale Source ]: SSIS Error Code DTSEOLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
Error at Data Flow Task [Sale Source ]: Opening a rowset for "'Sale Data$'" failed. Check that the object exists in the database.
commented on Nov 16 2011 12:54AM