Thank you for your response Phil. It helps in my search. Do you know what the dependent variable may be on the exe? The exe in question is a custom...

Pardon my ignorance, but what is SSIS farm architecture?

I have tried it as both TRUE and FALSE -- all to no avail. Might I also add that I am not using an Excel Connection to connect to the...

Thank you HappyCat59! You've made this cat very happy with your detailed response! I saw it happen both ways (changes have effects, or don't have effects) so I was curious...

Thank you for your prompt response, SSCrazy Eights. I am aware that the packages get deployed to the server instead of the agent -- please pardon my terminology. I hear...

FYI, the expressions for the connection strings look something like this (with minor tweaks based on file):

"Data Source=" + @[User::strCurrentFile] + ";Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1;\";"

"Data Source=" + @[User::strCurrentFile] +...

4 of the six are "Microsoft Excel Worksheets" (.xlsx) and the other two are "Microsoft Excel 97-2003 Worksheets" (.xls). The files are definitely not open for editing -- a common...

I assumed that may be questioned 🙂

What I mean is different data sets. So for example, let's say I have 5 "file types"...

1) Product Mix file

2) Sales file

3) Items file

4)...