Never seen anything like that before. Do all your dimensions take an age to run?

I would suggest making sure you have all the service packs installed. Then delete the dimension...

as far as I know it all depends on how you set up your sql server installation. I.e right click on the server in EM and select properites and then...

Look on the advanced tab on the dimension properites. You will see a yes/no for 'All Level'.

There is no need to use an activex task unless you want to enrich or change the data you are copying in.

Just write your query inside a Transform Data Task...

Why not just use the 'Microsoft odbc driver for oracle' from the connection windows. Connects just as you would an access db. Does not need tns names file to work.

You just need to create another dts package and use the dts package task. This is the yellow parcel with a blue arrow wrapped around it.

You can either call the...

I think it depends on how you have the db configured. For example, I have growth at 10%. I imagine that when the db needs more space it will take...

You need to check the box 'Always read properites from UDL file'. If it is unchecked, the information is cached.

Did you shrink the database afterwards. You will probably find that the space will not be reclaimed until you do so.

It sounds to me that you have some very large dimensions. Do you have any description type columns in the dimensions? It is not a good idea to hold large...

You could always WAITFOR, but I guess that effectively stops anyone querying the tables during update.

All I can think of is to query msdb..sp_get_composite_job_info to see if the job is still running. ACTIVE = "Y"

You will then need code to see when the job started...

I get you now. I don't know of a way to reporoduce the behaviour. I very much doubt there is unless you specifically build something.

Have you thought about using the read config task.

I created one to dynamically populate the destination file through activex.

You may be able to use global variables. See this link....

Have you thought about calling the dts package from vba and sending in the parameters you want to be dynamic.

You can give your users a locked down front end...