Thanks Jeff, I found that in BOL, and was drawing the same concusion.

I've decided on a new tact, just don't know how to do it yet.

Rather than using the indicator...

I have this in my notes, (written by someone other than me) but I have used it and varations of it many times:

/*

The first step to a duplicate-free table is...

See the following 3 articles for some ideas.

http://www.databasejournal.com/features/mssql/article.php/2204421

http://www.databasejournal.com/features/mssql/article.php/2235451

http://www.databasejournal.com/article.php/1503191

GL

If you start the dts-copy as your self do you  have sufficient authority on both servers because the job uses your account ? and on the other hand if the copy is...

try using the run method

Method:  WshShell.Run

WshShell.Run strCommand [,intWindowStyle] [,bWaitOnReturn]

The Run method creates a new process...

http://www.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp

Ensure your windows account is member of olap admin group on the server, and apply latest sql and AS sp on server and client if possible.

I have to vote for Hitchhikers Guide to the Galaxy !!!

All though very chessy, it was a great representation of the actual book.

besides thanks for all the...

If you're looking for a GUI tool, try

SQL Dependency Viewer analyzes Microsoft SQL 2000 and SQL 2005 databases and produces an interactive dependency diagram.

Its features include:

• Inclusion of all SQL...