Hi Andrea...

Later today I will find and post an example of a query I use that might help point you in the right direction...your question deals as much with sql...

Would you mind posting an example of what you came up with? I am curious how you went about this....

Thank you,

Michael

Michael Weiss

To the best of my knowledge, yes they need to be a part of the OLAP Administrators group. Check out Books OnLine (SQL Server Help) for more info...

hth,

Michael

Michael Weiss

Yep...I agree with Steve. The only other solution that comes to mind is to bring your data into a table in SQL Server and, using a cursor, walk through row...

This sounds like it is a function of the ODBC driver you are using. What dbms are you interfacing with?

Michael Weiss

I dont believe the order will be changed if you do not have a clustered index on your table. Also, it isn't always bad practice to not have a clustered...

The order of the records once they are in your sql server table(s) will depend on the clustered index, if you have any. All tables in sql server are ordered...

try submitting your question on microsoft.public.sqlserver.dts...could be someone there will have an answer...let us know if you find a solution, okay?

thanks,

Michael

Michael Weiss

Darn! That is right...I tried copying and pasting transform data task objects before and couldn't do it...sorry about the bum steer there...to answer your question, yes you should see the...

Darn! That is right...I tried copying and pasting transform data task objects before and couldn't do it...sorry about the bum steer there...to answer your question, yes you should see the...

Right click on the task, choose copy, then right click in the dts designer window and choose paste...or you could save it to a vb file then edit that file...

Yes I believe it is the Write Completion Status to Event Log option. You can view this information via the Event Viewer under win2k through start/programs/administrative tools/event viwer...should be similar...

Yes, have the package log events at the step level to the event log...this will tell you exactly when one started and completed and the next step or task started...

hth,

Michael

Michael...

I think you have to drop the cubes and shared dimensions, then rebuild them in order to utilize a different datasource...but before you do that, I wonder if it is...

Are you running SP2 for Analysis Services?

Michael Weiss