got it!  Thanks!

That is close.  I get an error on the objCMD.Execute line that executes the sp. 

Error is Incorrect syntax nere 'K:'

The "PAth" Variable = K:\Database\BtPers\GretchenS\btisdef.mdb

Does it not like the \ character?

Thanks guys.  You both gave me ideas that worked.  Now I only have one last conquest....

I am having troubles using xp_sendmail to create the e-mail message with the Path Variable. ...

The account the job runs under is both a local admin and olap admin on the server.

I tried to import data into ADP before.  What version are you running.  I was told by ADP they do not support or allow updates to thier tables.  Contact your...

The Shelf does not always contain a pefect sequence (1-5).  No shelf will have a duplicate sewquence.  This gets me some information. 

Yes, if he you have access to the master table there is a dts_ table that contains the password in plain text.  Great security!