Running DTS Package as Job

#1

I can run my dts package directly. However, when I schedule the package as
job, I get the following error message:

Executed as user: WIN\cis50SQL. ... OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL
Server Error Description: The requested properties cannot be supported.
Error on Line 24 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE
DB Provider for SQL Server Error Description: The requested properties
cannot be supported. Error on Line 24 Error source: Microsoft
Data Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4500 Error: -2... Process Exit Code 1. The step
failed.

Thanks,

Alim

#2

I have solved the problem!

"alim" wrote:

Quote:

I can run my dts package directly. However, when I schedule the package as
job, I get the following error message:

Executed as user: WIN\cis50SQL. ... OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL
Server Error Description: The requested properties cannot be supported.
Error on Line 24 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE
DB Provider for SQL Server Error Description: The requested properties
cannot be supported. Error on Line 24 Error source: Microsoft
Data Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4500 Error: -2... Process Exit Code 1. The step
failed.

Thanks,

Alim

#3

"alim" wrote:

Quote:

I can run my dts package directly. However, when I schedule the package as
job, I get the following error message:

Executed as user: XXXXX. ... OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL
Server Error Description: The requested properties cannot be supported.
Error on Line 24 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider
Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE
DB Provider for SQL Server Error Description: The requested properties
cannot be supported. Error on Line 24 Error source: Microsoft
Data Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4500 Error: -2... Process Exit Code 1. The step
failed.

Thanks,

Alim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Running DTS Package as Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Running DTS Package as Job - 11-15-2005 , 07:36 AM

RE: Running DTS Package as Job - 11-15-2005 , 08:47 AM

RE: Running DTS Package as Job - 11-15-2005 , 11:23 AM