Hi:  The OLEDB Provider for SQL Server 2005 is not "OLEDB" - Instead you should use SQLNCLI - Which stands for SQL Native Client, something like this

Provider=SQLNCLI;Integrated Security=SSPI;Data Source= "servername...

Under the notification tab I have it set to "Write to windows event log". That the only option I can use under this tab. My problem is not with the...

That was it, thank you very much. You are owesome

It has been scheduled at 7:00 PM and it does run fine at 7:00 PM but when I go to change the schedule it shows 12:00 AM. This is in...

thanks govvin, those two links are pretty helpful