That drive layout works very well in practice. The more drives the better is generally the idea, this spreads the workload out accross as many drives as possible.

Why don't...

Have you checked the query plan from SSMS to see if it is using the index? I am not sure that tables created in the current sproc are capable...

Altogether I think that the major points are listed. I will address only one point then. You mentioned replication, replication is somewhat better in 2005 and 2008, where...

Is there a firewall on the machine with Express, perhaps windows firewall?

If so then you might need to add and exception for sql.. I can't tell you what port because...

I really think we just need to keep honest people honest, profiler is an easy way to see the code, setting up a network monitor is a big step..

I think...

At the lowest level you should include those only if you can apportion them somehow, if not it might make sense to make them their own fact, the fact table...

How about turning on package configurations in the package and having it read the XML file. I must say though that the xml file structure is defined by SSIS...

The answer is yes you can, you can manipulate the entire object model from .net and both create a package from scratch in the object model and I believe execute...

You do need to do that step and define the structure, there isn't an easy way out.

Also, I have a question, what are you using files?

Can you not connect directly...

You cannot do it with the Lookup, you CAN do it by utilizing the OLEDB destination with the destination being set by a query, where you can execute an update...

Could you explain the layout of your package better or perhaps a screen shot to give us a better idea.

I'm working kind of blind here but you might be able...

I don't believe you can change it..

With that said, you can still use an inbox rule to handle distributions, you just have to look at the body more closely..

Can you...

As a side note, I just realized that I think you can use DTEXECUI to build a valid command line, that you could use as an example..

CEWII

We are going to need the command line that is being called to see the options.

At first blush I would say the command line calling dtexex is incorrectly built, but...

Do you use single user very often? IT is something that I admit I would be unlikely to check for. I would think long and hard before I...