Hello Agson,

The quickest way to create a report model based on a cube is from a shared data source in Report Manager (Reporting Services Web Portal). 

I have...

Hello Arthur,

For Query Analyzer try Help>About to get the version number. It will appear something like “Version SQL 8.00.2039"

The version number 2039 is SP4 and 760 is SP3a. 

Enterprise manager...

Hello Carl,

I have done this using the raise error t-sql command. This will cause the packages to error in most cases.

Have a look at online books for details.

Myles

Hello All. I agree we have not found the true cause of the issue. Just the permissions are the most likely cause of failure from what Keith has outlined. Remember...

Hello Keith,

did you login using the SQL agent service account and run the package manually?

Also you may want to turn the logging on for the dts package. you can out...

Hello Keith, you have to logout of your windows session and log back in under the SQL agent NT service account.

Hello all. When running DTS packages from SQL Jobs, the security context is SQL agents. If SQL agent does not have permission between the two servers or is running under...

Hello, this could be caused by secuity Permissions. Try running the package logged in as the SQL agent account. Myles

Hello,

Not sure if this is the right area to post too. Analysis...

Hello All, we are not having this problem with the MS OLE DB method, it is faster than ODBC.

However there are servile ways to improve performance with Oracle. It is...