Great Minds! I did actually try that on Saturday... created 4 seperate process tasks, and then tried:

a) All of them reliant on a SQL task (which just contained a comment)

b)...

Thank you very much for that Steve, unfortunately we're not allowed VB6 in this environment. I have .net express at home I keep meaning to look into but I would...

Aha, found it. Looks hopeful, I'll give that a try, Cheers!

By no means am I suggesting this is the ideal solution but if you are running SQL2K you can use a dynamic properties task.

Lots of our packages have details that...

Also... if you are processing cubes the account it's running on might need to have permissions on the cubes (aka OLAP Administrator).

If you turn on package logging you may get...

We had something similar once and it turned out the the program was waiting for something to happen on the Server. In the end we had to log on with...

Hiya,

Sounds like a good one! Did you restore the database to the same drive as it lived on before... just eliminating the hardware from the equation?

Mike

You could always try what we did:

Me: "Now you have this great BI system available to you, you can do all your planning in it."

Customer: "Yes, yes we...

All,

We've had a very successful implementation to about 10,000 users which we put live in 2001 on MSAS and a 3rd party front end...

Generally I've steered clear of incremental updates entirely as I've never had enough confidence I can completely control the source data automatically.

I like the idea and had toyed with...

The n tables... are they the same structure, just with differing data?

If so you could have 1 data pump with an interative loop controlled by your ActiveX.

Mike

Solved it. Colleague cheated and changed the FACT table to support the requirement instead.

2 random thoughts from myself... as this is something I have encountered in a slightly different environment:

Are the source and destination authenticating as service accounts... the same account?

I ask because one...

If you want both of these to run at the same time then create yourself 3 datasources. 1 for you SQL Server (Source) and 2 texts files for your destinations....

For dates like "SEPT 21, 2003" you can also get the Data Pump to do it... edit your data pump, go in the transformations and find the one it's probably...