Here you are:

set conn = server.CreateObject("ADODB.Connection")

conn.Open ("Data Source=" & serv & ";initial catalog=" & catalog & ";Provider=MSOLAP")

You are correct.  However, when I try to use a DSN-less connection, I receive an error saying that the Provider is not available or was not found.

Thanks, noeld.  The servers will be connected by GB ethernet and will be at the same location.  A SAN will be used for disk storage. 

I would be partitioning  fact tables the largest of which will have 1 to 3 hundred million rows and will likely grow at a rate of a 100 million rows per year.  The partitions will...

You should consider building partitions for your cube based on the Time Dimension.  In this way you can process the entire cube once and then only process the latest partition...

Open Analysis Service Manager and Right click the server icon and click on Properties... (The property dialog box opens).

Click the logging tab.  Under the Processing Log Settings section.  If...

1. The data load takes approx. 6 hours from each

2. EST users are in the system starting 8:00 AM EST

3. The load window is between 12:00 AM - 7:00...

Thanks Kelly,

This is what I found too.  It was the ODBC settings.  

I'd be careful with that proc.  I have used it myself and it has a problem decrypting SP's with more than 1 or 2 comments in syscomments.  The problem is...

Thanks!

Thanks again, Bob.  You are awesome!

More help needed.

I again wanted to thank you all. 

Yoda, its scary but I almost understood what you were talking about.

Bob, magnificent job in following the clues. 

You were able...

Thank you all for your replies. 

Thank you Bob for your very detailed response.  It sounds like you've encountered this issue before.

Great solutions!

It's not the most elegant solution, but you can use parameters in your template.  The syntax for creating a parameter is:

<parameter_name, data_type, value>

Use the Replace Template Parameter Dialog (Ctl+Shift+M) to...

The DTS packages are also stored in the MSDB database.  So replacing the MSDB database on the Target server, or inserting the records from the sysdts% tables from MSDB on...