Scheduling error but when run by the same user it is successful

[foxylady]

Hi
I am able to execute the DTS package but when I schedule it to run and the schedule is set up on my ID I get this error

****************************************************************************************************
The execution of the following DTS Package failed:

Package Name: VFPtoSQL_Property_DateChanged
Package Description: DTS package description
Package ID: {29E97192-349F-4571-97E9-442993C6BCD4}
Package Version: {82E295C9-77B0-43BD-A6C0-A0D5978020EF}
Package Execution Lineage: {D64A555C-67C7-4B29-A9BE-681915A6B472}
Executed On: DEVSERVER1
Executed By: CDog
Execution Started: 8/11/2004 11:40:02 AM
Execution Completed: 8/11/2004 11:40:12 AM
Total Execution Time: 10.14 seconds

Package Steps execution information:


Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 8/11/2004 11:40:02 AM
Step Execution Completed: 8/11/2004 11:40:02 AM
Total Step Execution Time: 0.015 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed

Step 'DTSStep_DTSExecuteSQLTask_3' was not executed

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Descriptionata for source column 101 ('market_value_percentage') is not available. Your provider may require that all Blob columns be rightmost in the source result set.
Step Error code: 80040E21
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:30701

Step Execution Started: 8/11/2004 11:40:02 AM
Step Execution Completed: 8/11/2004 11:40:12 AM
Total Step Execution Time: 9.984 seconds
Progress count in Step: 2000
****************************************************************************************************

any Ideas?