I have received the following reasonably definitive response.  Oh, well.  It was worth a shot...

[Y]ou have hit on an important point about trying this approach. Because you...

Not sure I understand the first question - "how do I get to them?"  If the locations are fixed and you simply want to cycle through all files (perhaps with...

My answer depends upon what you mean by "scalability."  If you mean number of users, I have not seen a problem directly as a result of number of users since...

Andy,

I feel compelled to reply.  64-bit was our salvation for our OLAP performance problems.  The pain we felt during the week it took to convert our 40+ packages to a DTS-DB...

I could have sworn someone showed an example of such code at SQLPASS in a talk on DTS best practices.  Anyone remember that?

We were hit with the same rude surprise when we migrated.  Short version - keep DTS on 32-bit.  It might run, but you are on your own if you do...

Depending upon the environment, our DB, OLAP, DTS, logging, and files used may be placed on a single box, all on separate boxes, or somewhere in between.  I wish I could say...

It depends upon what your goal is.

Because our development, QA and production environments differ greatly in configuration, we started putting a set of dynamic properties and ActiveX tasks at the...

At SQLPASS, I was told that Yukon is supposed to have "real" partitioning, in which the partitions can be managed individually, taken on/offline, etc.

Larry

This sounds like it could be handled in a stored procedure.  Check for dups in a SQL statement in the procedure.  If they exist, call another stored procedure to email...

Well, you can - sort of.  You can do looping using ActiveX script to play with the status of the steps.  Check out or http://www.sqldts.com/?246 for a good example.  If...

We selectively turn it off for certain ugly queries. 

We have one system that has double-digit millions of rows in each of 36 (and growing) partitions of a union partitioned...

From the "announcement" email:

QUOTE:

It is with great please that I announce an updated version of the PPU (V3) is now live.

See the attached readme.doc file for all of...

Okay - way out on a limb - no time to fact check, you assume all risk, etc.

As I recall, all OLAP tasks "execute on the main package thread", so...

Why should this surprise anyone? Any large production system is usually treated with great care. As Patrick mentioned, the answer many DBAs default to is "NO!" regardless of...