RSExecutionLog_Update.dtsx error!!

Hi,

When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem?

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

RSExecutionLog_Update.dtsx error!!

Hi,

When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem?

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

sql

rsactivate error message

Hello all,

Since I installed SQL Server 2005 on the same server than SQL 2000, my Reporting Service is getting me this error:

"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help

Bad Data. (Exception from HRESULT: 0x80090005)"

I looked over some other logs and forums, and pretty much all pointed to use the rsactivate utility. Well, I am getting frustrated trying to run the rsactivate utility since I typed in the command rsactivate -r and got an error message that didn't expect to get.

Ej:

C:\>rsactivate -r
Either the WMI provider or the path to the local config file must be specified

Then I typed in the path and still got this:

C:\>rsactivate -r "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
Either the WMI provider or the path to the local config file must be specified

Does someone out there have had this situation or escenario before and what you did to solve it?....

I really need an input or hint on this, so I will appreciate any help.

Thanks in advance.

AJ

Hi I think your using the wrong command... To reactivate you must use the -c option, try this command reactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"