I had a dts package . When I run the package the data gets loaded into excel. The data gets imported into the application.

But when I use ssis by using the same logic to load the data into the excel file the data gets loaded into the Excel.

But when I Import the excel to the application.The excel sheet doesn't get imported. It tells to me that a valid spreadsheet is required.

Any IDEAS. Please help

Thank You,