April 9, 2010 at 5:51 am
We tried executing SSIS packages [4P & IMS] where database is pointing to Cluster server. We could successfully run them in BIDS but not through command prompt [SSIS package is invoked in a stored procedure].
We got the below error.
Error: 2010-03-24 07:01:25.99
Code: 0xC0012024
Source: ST_Enter JobID
Description: The task "ST_Enter JobID" cannot run on this edition of Integration Services. It requires a higher level edition.
End Error
We have investigated to find the cause of the error and observed the following.
The Cluster server is having enterprise edition and reporting server is having standard edition.
Please find the query/details below. And that is how we found these.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Cluster Server
9.00.4035.00 SP3 Enterprise Edition (64-bit)
Reporting Server
9.00.4035.00 SP3 Standard Edition
April 9, 2010 at 6:05 am
You posted the problem and Solution as well . then how and where we can help you ? 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 12, 2010 at 2:56 am
can u please provide solution. i dont know where i have to provide the solution.
April 13, 2010 at 12:41 am
chanti2985 (4/9/2010)
We got the below error.Error: 2010-03-24 07:01:25.99
Code: 0xC0012024
Source: ST_Enter JobID
Description: The task "ST_Enter JobID" cannot run on this edition of Integration Services. It requires a higher level edition.
End Error
And Your solution
We have investigated to find the cause of the error and observed the following.
The Cluster server is having enterprise edition and reporting server is having standard edition.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 13, 2010 at 12:46 am
See this also http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/321bda9d-0971-47a1-b65e-ee01bdfb0fc1
http://www.bigresource.com/Tracker/Track-ms_sql-bfOhjw3U/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply