I have created a DTS package that runs fine when executing it directly, but fails consistently when trying to run it from a sheduled job. It seems to be able to process the package all the way up to the point where the data pump kicks in. I can't figure out why. If anyone can point me in the right direction, I would be grateful.

... DTSRun: Executing... DTSRun OnStart: Drop table [AMISYS].[dbo].[code_m] Step DTSRun OnFinish: Drop table [AMISYS].[dbo].[code_m] Step DTSRun OnStart: Create Table [AMISYS].[dbo].[code_m] Step DTSRun OnFinish: Create Table [AMISYS].[dbo].[code_m] Step DTSRun OnStart: Copy Data from CODE_M to [AMISYS].[dbo].[code_m] Step DTSRun OnError: Copy Data from CODE_M to [AMISYS].[dbo].[code_m] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Mana... Process Exit Code 1. The step failed.