That is awesome thanks again for the help I really appreciate it.

This has worked great but I would like to store the results in a table. Can I insert the return into a permanent table?

Thats awesome! I really appreciate your help thank you.

I am getting the below error

Msg 102, Level 15, State 1, Line 38

Incorrect syntax near 'CTE'.

This is working great thank you very much for your help.

Let me see if I am following you:

Create an empty excel file (Template)

Job

Copy empty template to folder using the name that is built dynamically

Insert data using the name that was...

I added the variable value from the Loop container to the connection string property of the Excel connection manager and received this when I ran it.

Error: 0xC0024108 at Excel, Connection...

I get an error when I put this into the connection string property of the connection manager.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=\"EXCEL 8.0;HDR=YES\";"

I was able to finally get it to work. I had to Cast the variable and allow for a longer string. Thank you for your suggestion.