correct...my mistake, i haven't read the line carefully!

to fail the container on a failure, the best option is failparentonfaliure=true... i agree...

i was thinking about catching the error and continuing the flow. 😉

Are you looking for a native tool...

if so you can use compress

http://www.microsoft.com/downloads/en/details.aspx?familyid=9D467A69-57FF-4AE7-96EE-B18C4790CFFD&displaylang=en

for that u need to ask ur admin to install this toolkit for u.

Well,

one option is like....you can add some logging task inside the container and connect that task with all possible error outputs from the different tasks inside the container.

and in the...

In most of the cases,

When you deploy and schedule a Package using SQL Agent Job, the package should be on the agent account,

And normally its should be NTAuthority/NetworkService

Please check that...

The best option should be 7zip which is an open source licence

we have a 7-Zip Command Line Version available for download(http://www.7-zip.org/download.html)

use that one with commands as Expressions along...

This might be due to access restrictions,

in debug its running on your windows account,

but after deployment it should be on Service or SQL Agent account...

So if your package accessing restricted...