iowaind - You don't have to delete report.xls. Having a file copy task with overwrite set to yes will do it automatically.

fstop - I'm pretty new to SSIS and SQL Server myself, but with a long background in Excel and Access. I've not used import and export myself and I' m finding it hard to visualise what you are describing.

I suggest you start from new. Create a new empty package (and a new project if that helps). Drag a File task into it and set up as I described above, then drag a data flow task in and edit this.

It will need a source, and a destination component at least, but probably some transformation stuff in the middle. Do a simple version at first and gradually enhance it till you get what you want. That way you should be able to work out where you are going wrong.