You'll need to pass the step object to a COM component as a variant as the method requires strongly typed variables.   here is the code for a method in a...

Hi,

What I was suggesting is you restore an empty OLAP DB schema to your production server and re-process your cube.    There is no requirement to stop and restart a server...

You're playing with fire if you do so but you could go into the metadata for the cube in MS Access or SQL Server DB and change the relational data.

I...

Why?  Is it an issue of the underlying data for the relational cube no longer existing?

If not, your best bet is to copy/paste (as empty DB)/archive/restore/reprocess on the new server.

Just my...

I seem to recall that George Spofford in his MDX SOlutions book had a solution for this.   You might try googling on "Spofford" and "Standard Deviation"

HTH,

I might be missing the point but why wouldn't you just set the information into global variables and then use a dynamic properties task in the DTS package to configure...

Since you are not likely to distribute the DTS COM DLLs with your Java code, I would suggest referencing the below:

http://www.sqldts.com/?210

And call the package from TSQL via JDBC.

Thanks.

Hi.

I haven't really ever seen restoring CAB files work better than just reprocessing the OLAP database.   Personally, I would focus my energy on having on hand an OLAP Schema that...

Lori,  you have a PM. 

What type of task is it? You can always stabilize tasks that aren't free threaded by editting the workflow properties and setting the "Execute on Main Thread' prop to...

You could always modify the workflow properties of each task in the package to "Close Connection on Completion" this will free up the exclusive lock on the Excel file without...

Definitely a high level (somewhat academic) review of Data Warehouses. The clients my company interacts with don't have "steering committees" but do have business needs that we are...

Decent article....

Why not just use a UDL file for connection information? A UDL file is a better candidate because it can be RE-USED across multiple packages.

Good of you...