Hi Steve,

If I add the Aggregations to the cubes, will the existing data in the cube be retained or lost,as the fact table for the cube does not have the...

Dear Steve,

Thanks for the reply.

Yes, we have not created additional partitions and also no aggregations. The cube has the default one partition only.

Can I create aggregations on this single partition?

And with...

I have set 'Insert Batch Size'  as 2000 as suggested by Phill and its going fine now without hanging.

Also I executed the package by setting it to 1000 and realized...

Hi Colleagues,

Thanks very much for the reply.

I will try to adjust the setting as suggested by Phills and run the package again.

ACtually the second table for which it takes long...

Hi Raj,

Thanks very much for the suggestions.

I have changed the Log On Account for SQL Server Agent same as the Login Account on the server and the problem is resolved.

Regards,

Asif

Hi Phill,

Thanks for the reply.

Connection to the INGRES database is successfull when I try to test it through ODBC.

The error which I'm getting is as follows:

Executed as user: ED21\SYSTEM. DTSRun: ...

Hi Luke,

Thanks very much for the reply.

"Execute on main thread" option was already ckecked for each Task.

I'll do the suggested setting i.e. "Close the connection on completion" and the try...

Hi Steve,

Thanks very much for the efforts.

Yes, my data does have the duplicate names.

Let me explain it.

We have a Client say 'O', this client will have business partners 'P1',...

Hello Colleagues,

Thanks very much for your interest and suggestions.

I have tried the suggestion given by Urvashi,it is working fine.

Regards.

Hello Colleagues,

The package works fine with INI file.

But still I have to change the table name manually in INI file.

Actually name of the tables(One table per 2 days of a month) which...

Thanks very much.

It helped me.

Thnx Tejal,

I applied sp3 and it is working.

One more question,

Will there be any problem if the latest patch i.e. SP4 is applied on SQL2K Analysis Server?

Thnx