I have configured the connection manager properly. The Protection level of the SSIS package was the default option (EncryptSensitiveWithUserKey). I have now checked with DontSaveSensitive and then EncryptAllWithPassword options (I...

Hi,

I am facing the same problem when I try to process a dimension. But I am using Oracle 10g client. I have installed both 32bit and 64bit Oracle 10g clients...

Truncating the log file (using backup log) truncates the logical log. That means there is no reduction in the physical log file size. To reduce the physical log file size,...