A friend asked me to post this to see if anyone on the list could help him solve his SQL7 error. If you have any ideas as to the problem or resolution, please send me a private email. I've attached a text file containing the details of the failure I'm getting trying to run the stats upload program into the SQL7 database. This all used to work and there has been no changes, so something has "broke" inside SQL7. The stored procedure was created using the DTS wizard. All it does is look for a file named "masterfile" in the c:\ftp directory and if it finds it, it uploads it into the "collected_data" table of the "data_collection" database. That's it! _____________________________________________________ EDI-Mike Michael Taylor EC Specialist Banctec - Corporate Information Systems (972)982-2815
"Job Outcome" Results: The job failed. The Job was invoked by User APPS\Data_Collector. The last step to run was step 1 (Upload_Data). "Upload_Data" Results: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1 DTSRun OnStart: Copy Data from masterlist to [Data_Collection].[dbo].[collected_data] Step DTSRun OnError: Copy Data from masterlist to [Data_Collection].[dbo].[collected_data] Step, Error = -2147008507 (80074005) Error string: Could not acquire a FastLoad session.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: Could not acquire a FastLoad session.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: Timeout expired Error source: Microsoft OL! E DB Pro. The step failed. "Upload" Command: DTSRun /~S 0xAC3F8789F3F74E159592FD86BB711E7EB6C55AFC6FB79EAA /~N 0x19621B5CEFED3449592790E92F9840F4D07A7222DF864695 /E
