Given what you are describing I would start with permissions, since that is about the most common problem.

CEWII

Probably need to re-install SSIS, I've seen this with messed up installations.

CEWII

First, what are the errors return out of the other items when one of them fails?

Second, the method described where a package is executed repeatedly is very likely ultra inefficient,...

Are we sure the version in QA is EXACTLY the same as the prod version. Also, does the package call any other packages. However, I did have another...

I would tend to agree. learning at least a little vb.net or c# is required, and most of that will be usuable in the Script Task.

CEWII

Is the datatype for Query1RowNumber & Query2RowNumber exactly the same. I'm not asking if the query is the same but the underlying datatype of that column. I know...

Are you doing it with a passive connection? If not it is probably the connection coming back in through the firewall which isn't usually allowed.

If you are then the...

For the command line you might reference:

http://www.google.com/url?sa=t&source=web&ct=res&cd=1&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.lexjansen.com%2Fphuse%2F2006%2Fcc%2Fcc01.pdf&rct=j&q=wzzip+command+line+parameters&ei=JfD9S-L2KJWyNtjsmNEN&usg=AFQjCNEZWxafxZB825KFgpo-UZg25qLNPg&sig2=cOvz9cZ_Kj5Y-ifCYmtkNg

Within the F-E-L I would probably add a script task to actually do the calling. I don't like the Execute Process component very...

I would tend to agree with the lookup method. It would likely be much more efficient than a one-by-one lookup.

CEWII

The mappings between source and destination columns MUST be done at design time, this makes what you are proposing difficult with the provided controls. I believe CozyRoc has a...

I have experienced something like this before..

The desktops were configured to proxy FTP and had a piece of software to allow that. The servers did not, and by policy...

As far as templates I am generally for them, however read this article and decide for yourself:

http://bi-polar23.blogspot.com/2009/09/ssis-package-templates-good-bad-and.html

CEWII

I pretty much what the poster before the last post does. I take it a step further and mark the file read-only so that I have to go out...

You are welcome. I have used this logic many times and it has worked great for me.

CEWII

I would tend to say SSAS and SSRS should probably be on different servers as opposed to SSIS. I usually like to keep SSIS as close to the DB...