Hi Folks...
One of my pal, when he was trying to create SQL Server Job to call a SSIS he got the following error;
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
When we googled for the same it was mentioned in lot of forums that the it worked fine once we install SQL Server 2005 service pack 2 (SP 2)
Reference: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e7c0e73e-8d4b-4624-a19e-352a69995f9e
Download: Microsoft SQL Server 2005 Service Pack 2
Regards
Fauzi ~ 4Z
Showing posts with label Schedule. Show all posts
Showing posts with label Schedule. Show all posts
Monday, June 8, 2009
Sunday, September 7, 2008
Solution for SSIS job : The package execution failed. The step failed.
Hi...
I created a dtsx package which will fetch data from Excel file and insert them into respective SQL Server table. When i run the package from SQL Server Business Intelligence Development studio it works fine. When i run package from Command prompt also it works fine. But when we create it as a SQL Server Agent Job, It says the following error.
The package execution failed. The step failed.
I found this article from Microsoft Support team for all scenarios while execution of Job failed.
http://support.microsoft.com/kb/918760
It was clear, in my case it was permission issue, So i kept looking for blogs on such case. Managed to find this blog which helped me to solve the issue.
Following are two points which i believe, did the trick for me...
1. Under SQL Server Configuration Manager:
* Right click SQL Server Agent(MSSQLSERVER)
* Click Properties
* Select radio button this Account, Gave the User Name & Password (the user name with which i have created the .dtsx package )
2. In Computer Management(Right click on my computer & Click Manage)
* Under Local Users and Groups
* Under Groups
* Right Click SQLSERVER2005SQLAGENTUSER$YourServerName$MSSQLSERVER
* In Properties add the user name with which i have created the .dtsx package
These steps solved my problem, Hope this should be helpful :)
Regards
Mohammed Fauzi
I created a dtsx package which will fetch data from Excel file and insert them into respective SQL Server table. When i run the package from SQL Server Business Intelligence Development studio it works fine. When i run package from Command prompt also it works fine. But when we create it as a SQL Server Agent Job, It says the following error.
The package execution failed. The step failed.
I found this article from Microsoft Support team for all scenarios while execution of Job failed.
http://support.microsoft.com/kb/918760
It was clear, in my case it was permission issue, So i kept looking for blogs on such case. Managed to find this blog which helped me to solve the issue.
Following are two points which i believe, did the trick for me...
1. Under SQL Server Configuration Manager:
* Right click SQL Server Agent(MSSQLSERVER)
* Click Properties
* Select radio button this Account, Gave the User Name & Password (the user name with which i have created the .dtsx package )
2. In Computer Management(Right click on my computer & Click Manage)
* Under Local Users and Groups
* Under Groups
* Right Click SQLSERVER2005SQLAGENTUSER$YourServerName$MSSQLSERVER
* In Properties add the user name with which i have created the .dtsx package
These steps solved my problem, Hope this should be helpful :)
Regards
Mohammed Fauzi
Subscribe to:
Posts (Atom)