Agreed, one size does not fit all, however there are some fairly hard rules to follow.

1. Use a Source Control system, SVN, VSS, TFS, Vault, etc.

2. All code deployed is...

Silly question to start. Is the most recent SP installed for 6.5? If so, move on to the rest of the answer.

There is an option that a lot...

Mapped drives are a bad plan using SSIS, stay away.

CEWII

Keep in mind when these articles were written and whether they still apply in light of the ACE 14 components. But definitely read them.

CEWII

Can I ask a larger question?

Why are you designing the packages right on the server?

How do you handle version and code control? How do you prevent 2 people from...

Right tool for the right job..

All of the tools mentioned are BIG $$$$$$$$$$. And some can do things that SSIS can't, however, even for obscene amounts of data SSIS...

Pavera22 is on the right track, but I think that overall this is a lot simpler than you are making it.

As I see it you need an exec sql task,...

You will need to install them on both locations, the server that the package will be running on and the machine used for development. I would assume the installer...

I also think you need to keep in mind that drives is not the most granular level of space allocation. You can have mounted volumes that have their own...

I agree that the no-caching solution would be terribly inefficient.

I also think we need to remember rows in the pipeline that haven't been into the later stages of...

I have seen some multi server setups that all point to a single config server, and that config server uses the host_name() in the where clause, what it does is...

You can do this fully within SSIS with a script task. I would suggest an encryption like AES-256 to encrypt the password, you could store the PW in the...

Please review the link I sent, I don't believe it is beta anymore, I could not find a single reference either on the download page or in the install that...

I don't know if the reasons are few and far between, but I think the more important issue is understanding WHY you would chose to go either more or less...

Here is the MS download link for the ACE 14 files:

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

I don't believe it is beta, I believe this is the release redist version.

And I would start a new thread...