I understand updating the connection manager but do I need to execute a data flow task?

More detail...

In SSRS when a .csv is generated the columns are created with an "underscore" when there is a "space" in the header name. The column header must restore the...

Thank you for the information. Will this work if I want to change the column header itself? I'm following the steps but does derived column only update the contents within...

This is exactly what I needed. Thank you so much for the info!!!

I see SSRS only exports as CSV (comma delimited) or CSV (Tab delimited), I actually need tab delimited.

That was the issue. Once I built the metadata with a template file the issue was resolved. I also found that I needed to set the "FirstRowHasColumnName" via expression once...

Yes the columns are the exact same, the only change is the file name and sheet name.

I want to also make sure that I'm configuring the data flow correctly,...

I want to first thank everyone for your time and assistance. I really appreciate it!

I recreated my package and .xls file and in doing so I found that my file...

I attempted to write a simple select statement directly in query editor and received the follow error:

TITLE: Microsoft Visual Studio

------------------------------

Exception from HRESULT: 0xC020801C

Error at Package [Connection manager "Excel Connection...

Thank you PHYData DBA.

I followed the listed steps and when I select "Build Query" from the Excel Source editor the following are the details of the error:

===================================

The Query...

Thank you HakunaMatata for the recommendation. Make sense but I apologies for my ignorance, can you provide or guide me to some resources with the code the that will save...

The file is valid. I can open in Excel on a local machine without an issue.

I receive the error in the "Excel Source Editor" when clicking on "Columns". Also,...

Agreed but unfortunately I do not have any flexibility with the file type. I would convert to .xlsx if I had the option as I already have a package successfully...