1
Vote

RSExecutionLog_Update ssis package error

description

Hi There,
 
I just download SQL 2008 version of Server Management Report Samples on
Execution Log sample reports from
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Server%20Management%20Sample%20Reports
 
There is step to run RSExecutionLog_Update ssis package to update log data,
however when I open the package, I got "Error 2 Name 'Dts' is not declared."
error. This is the package provided by MSFT, could you please advice how to
fix this?
 
It seems that ssis package is still SQL 2005 version since it gave me warning saying "warning, found sql server integration services 2005 script task that requires migration". Please post the sql 2008 version of ssis

comments