I've resolved the Stored Procedures. It was combination of issues and resolutions, some not related to the SP so I won't list here.

Thanks for all the response.

Continued:

SELECT * FROM sys.objects

Returns Invalid Object.

Example:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pru_assignedseats]') AND type in (N'P', N'PC'))

I re-gen'd the script suig SQL 2000. REceived error : Invalid sys.object

Then edited one sp from begin call to end and this was succussful. Ran a group of create sp's...

I am uncertain how to determine if through SQL Agent the service account has ro hasn't permission.

The job is being run by sa, cmdexec---

My experience in Sys Admin...

Resolved: Thanks for the help!

I set permissions to the file being written to everyone and that appears to have solved the problem

Thanks to all who responded... RM

I've added the full path, checked permissions on Db,files and all seem correct.

I'm posting error, hoping it may provide more clues.

Message

Executed as user: IIS-B\SQL. DTSRun: Loading... DTSRun:...