The stored procedure is ran inside of Query Analyzer. It calls the DTS packages via sp_OA* to create, execute, and destroy the objects.

Even if I manually run the DTS...

Thanks for the quick reply! Let me make sure I understand what your saying...

Are you saying that the 'sqltest' account I created needs the mapped drive for it's user profile?...