DTS Schedule Error - Parameter is incorrect

[Nisha]

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[Ray Miao]

What kind of changes did you make? Any details?


------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[Hemanth]

Give me the "Command" in the step of the SQL task.


------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[Siddu]

Delete the schedule from jobs.
Create a new schedule from the DTS.


------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[Aakash]

do you have permission to excute commands on that BOX(Server)

------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[NISHA]

Hey Thanks all..
It was due to editing the DTS on SP1 Server from a cleint running on SQL Server SP2 and saving it .

Thanks once again

Nisha

------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.

[NISHA]

Hey Thanks all..
It was due to editing the DTS on SP1 Server from a cleint running on SQL Server SP2 and saving it .

Thanks once again

Nisha

------------
Nisha at 8/7/00 3:25:52 AM

Hi all Thanks in advance ..

I have some DTS Shedules on SQL 7.0 SP1 . All shcedule was running properly . When I made some changes in an SQL Task and saved it the shedule starts to fail. It gives me an error "DTS RUN LOAding Error- 2147024809(80070057)Ptovider Error (0) Error String : The parameter is incorrect etc)
But All my DTS is running smoothly without error Only the schedule fails.
Please help me.