I have a program that uses DTS to process dimensions and cubes. If the OLAP
server is on the same machine with the data warehouse database, and then it
runs fine. If the OLAP server is on a different server, and then the DTS
process, at the end, put the error message "Source data contains no rows..."

The program makes connection to the server (SQL/OLAP) using Windows
Authentication, and both services (SQL and OLAP) are running under an NT
login user that have administrator rights on all boxes.

What is wrong? Can someone shed a light?

Thanks.