This is very easy to accomplish with an Execute Process task in the control flow without having to do any scripting. If you need a concrete example, please let...

Good point: for any command line-type tasks, I always work with them outside of SSIS to nail down the exact syntax that I need (including the relevant flags/switches) to get...

(too clarify, that last expression in my response is for the Args variable to be used in the Exec Process task)

Try something like this in your Execute Process task:

Executable: [full path to your .exe]

Args: [set this as an expression to a variable]

Working Dir: [working dir of your .exe]

Create variables (can...

Partially: if you run PowerShell using COM objects to extract the data, then yes, Office is required and will load on the machine that the script runs on. Otherwise,...

Just another thought on Excel books that you don't control: parsing the Excel to a flat file using PowerShell or Perl is very handy, and also avoids metadata issues, if...

You can sort the files into an object variable in a Script Task, which can then be iterated through in a For Each Loop container (ADO Enumerator). Attached is...

Quick Q: was the password on the original Excel book a password to open the book, or was it a password to protect the workbook from changes? If the...

In a situation with a large number of directories/an environment where there are always changing destination directories, I agree about the number of connections and maintenance considerations. (depends on the...

You can also do a conditional split based on that column which can then send the data down the pipeline to the appropriate destination file output (located in the directory...

Short answer is, you can't.

If you don't know the password, and you're not even able to open the file (no Read Only option), then you're not able to do this....

One thing to keep in mind is that breakpoints will cause that expression-based variable to be re-evaluated at the time that you step past the break point. If you...

Another thing to try, without using a loop container, is the MULTIFLATFILE connection.

You'll still need to set up a connection string in its properties (which can be controlled by a...