I need help in understanding how the cubes and tables of the application data has to layed-out in the filesystem of the database.

Thank You Richard,

I think I got the answer.

Thanks,

Sree

Please anyone help me in understanding this.

Thank you once agian for your valuable SP.

I was in the middle of writing a SP to get the job start time and end time in SQL Server2000, now I...

Hi Manu,

Thank you very much for providing me with the SP.

I have a crazy doubt, please correct me if I am wrong.

Is the date and time shows the time at...

Thank you Lynn for your reply

I will work on this and will update again if I have any other issues.

Thank You Again,

Sree

Hi,

Thanks for the replies !!!

The sysjobschedules doesn't provide me when the job started and finished information. Also, I am not looking for the next run date or last run...

Thank you for answering my question and help me undersatnd it !!!

This is cloning of SQL Server Instance not the VM....

If its possible ..is it possible for the default instance...

Thanks Everybody for your valuable solutions.

It was an urgent requirement for me so we have decided to use the 32-bit server to create reports for Oracle datasource.

In 32-bit everything is...

This is where I am still struck, I am still getting the same error even after twicking here and there :

I have installed both the 64 and 32 bit oracle...

Thanks for the reply.

The issue is not with scheduling SSIS packages on 64or 32 bit environment.Its all about how to use Oracle as a datasource while creating reports in BIDS...

Hi Steve,

Thank You for providing me the document.

We have a senior Oracle DBA in our company who has seen this and is helping me to solve this.

He did the uninstalling...

I am able to connect to the oracle instance through sqlplus also from command prompt without any error messages using both the oracle clients.

I dont think its an issue with...

Thank You very much for the explanation Steve !!!

I have installed both the 64 and 32 bit oracle clients.

I have created a directory D:\TNS and put the tnsnames.org file there.

After...

oops forgot to mention..the server is in mixed authentication and I have adminstrator previlages on the server.

I am not sure where exactly the security settings are going worng.

Thanks for all...