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?
I have exactly the same issue. It runs fine within BIDS but when I Add the SSIS package to my server and attempt to run it from there I get the same error.
Any ideas???? Anyone????
I believe mine was fixed when I updated both the server and my developement machine to latest SQL 2005 service pack.