Hello all,
I am having a problem creating a job step that will run a SSIS package. I go to add a job step (or edit an existing one), but when I select 'SQL Server Integration Services Package' as the type, an error box pops up with the following message:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)
After I hit OK, it goes back to the 'New Job Step' window and makes me select a different step type.
I am running on a Win2000 Advanced Server with SP4, a default instance of SQL2000 with SP4, and a named instance of SQL2005.
Does anyone know what is wrong or of a workaround?
Thanks in advance for any and all help/comments.
Jarret
Whatever the problem was, restarting the server fixed it. I hadn't restarted the server since I installed SQL2005, because the install didn't require a reboot. I had a chance to do so over the weekend and when I checked on this problem, it was gone.
All is good now.
Thanks!
Jarret
No comments:
Post a Comment