Thanks for the suggestion. I noticed there was an OpenRowSet property in the property page for the Excel Destination object. It already had the name of the worksheet...

It's a normal SELECT query that I've used over and over again in the old environment (SQL Server 2000) and it works as designed. I'm thinking there are some...