Did you try using the cmdline version plus the outdirection of the 7zip log?

Can you try outdirection on the call to see if anything else will be logged? The exit code 2 just means it's a fatal error.

🙂 you got me on a bad day 🙂

What is the error you're getting when you try to run the package versus the steps individually?

To prove out your...

Agreed, not overly pretty. You could try using the .net FileSystemWatcher class itself, so basically 'rolling your own' specific FSW. A reasonable example for watching for multiple files is here...

Oh, and make sure you're using the cmdline version, which I think is 7za.exe.

Exit code 2 is a fatal error in 7zip, but that doesn't tell us much really.

Have you tried outdirecting the command? Something like

7zip.exe parms > mylog.txt

See if that will...

LMGTFY.......

first hit ->https://social.msdn.microsoft.com/forums/sqlserver/en-US/f9239a7e-17c7-4af9-ad12-01f3baaaed40/ssis-problems-with-7zip-when-run-using-sql-agent-job

It's permissions.

Multiple (ie 15) filewatcher tasks? You could then use precedence constraints to ensure that the next step doesn't start until all 15 arrive?

In a way, some of the answer depends on the delivery mechanism you're going to use and the experience level of your user base.

SSAS - much more than just having...

No, that's a general rule of MDX, a set needs to have members that share the same dimensionality.

Having said that,...

Logging is possibly turned off. It depends on which mode it's running in, for how to switch it on (ie sharepoint vs native). This link tells you how to enable...

Have you taken a look at the performance guide? It covers performance for both build and query of cubes.

I don't have it in front of me right but, but I'd be surprised if MDX Solutions (Webb et al) didn't cover something similar.

This article is old (ie circa SQL 2000) but the concepts remain the same - you want to look into semi-additive measures, and likely 'closing balance' (or value). You...

Appears to be "how do i convert this sproc to an SSIS package"?