Okay We have made progress. I now am running the same service packs on the Production Server and Design Notebook. I no longer get database in use or access denied. I do, however, get the following error when running the job. the package still executes without fail when executed manually.

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Drop table Courses Step DTSRun OnFinish: Drop table Courses Step DTSRun OnStart: Create Table Courses Step DTSRun OnFinish: Create Table Courses Step DTSRun OnStart: Copy Data from Results to Courses Step DTSRun OnError: Copy Data from Results to Courses Step, Error = -2147217887 (80040E21) Error string: The property 'Use Encryption for Data' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: The property 'Use Encryption for Data' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Errors occurred Error source: Microsoft OLE DB Pr. The step failed.