Thank you Steve. Yeah I looked at the performance guide, but not much was given on what each of performance counters indicate and what can be interpreted from each. I...

Oh I didn't know process update was only for Dimensions. I was actually talking about partitions. I had typo on the name of my partition. And the SSIS package script...

Thank you for the resources. Actually I checked the profile and it was the query issue. The query was running forever on the oracle side and never returned the dataset....

the cube size is about 70 GB. it was running fine a few days ago and it is very slow now. We don't have a lot of aggregations. But it...

Thank you Koen and Steve. This is very helpful. I will try the suggestions from the session using profiler. The back end is Oracle . I am not sure how...

My connections from SSIS catalogs show Provider=MSOLAP.6;Integrated Security=SSPI;Impersonation Level=Impersonate;

I am so confused about how all the security is working. If it uses the connection string above, does it mean it...

The previous user had EncryptSensitiveWithUserKey for the package. What is the best way for me to edit the package and deploy to SSIS catalog and have it run the same...

Please let me know if there is a way to alias servers.

I saw in the below article that there is a way to alias Database Engine, but not SSAS...

I am finally able to confirm the problem.

The problem occurs only when connecting to oracle using the script task using the code below. If I connect using an Oracle...

There seems to be a different problem than the oracle drivers.

I made the package simpler by just using one simple script task. And used in the job with files...

Hi Nevyn,

I used this query to find that it is 64 bit enterprise. But when I remote logged in. I was only able to find a 32 bit dtexec. I...

Hi,

Actually even after installing the 32 bit client, there is a different error. Does anyone know of problems when installing the Oracle 32 bit and 64 bit clients together? Please...

Hi Koen,

Thank you for your quick response.

The errors are due to the fact that the admins upgraded the oracle client from 11 to 12. They say It has been 64...

Thank you Koen,

With SSIS package logging, I mean the sysssislog system table. We dont have any user databases in SQL server. We use sql server only for ssrs, ssis and...

For my case, the expected run time is hard to know because each subscription is scheduled to run every hour. If the ETL process finishes by that hour, then the...