Error Executing, SSIS Packages Coppied from another server

Hello All,

I am working on an application used to move packages (SSIS Packages) from one server to another.The packages are saved under MSDB folder.

Case: When the application is running on my system, i try to copy packages created from another server to my Server.I am using package protection level as "Server Storage". When i try to execute the coppied package from my system, it is giving me error.
An oledb error has occured, Error Code 0x80040E4D, An Oledb record is available, Source : Microsoft OLedb Provider for Sql Server", Description : "Login failed for sa".

Case : When the Package Coppier application is running on my system, i try to copy packages created on my server to my another Server.I use the same package protection level as "Server Storage". When i try to execute the copied package on destination server it is working fine without errors.

Please guide me on this issue, as soon as possible

Thanks And Regards
Subin

Make sure all the permissions are properly set on your server.

DId you read this (http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx)

ServerStorage. No encryption is added to the package. Instead the package’s contents are secured based on the database’s object access security. If the ServerStorage value is used, the package must be saved to SQL Server in the sysdtspackages90 table in the msdb database. It cannot be saved to the file system.

The SSIS package security model is also extensible. There is a Sensitive attribute in the XML schema of an SSIS package that controls access to the package’s properties. For example, if the Sensitive attribute is set to 1, when the user opens the package all sensitive data will be removed. Developers can incorporate this Sensitive attribute to get the same type of protection for their SSIS custom components.

If you are using the ServerStorage ProtectionLevel property, the method of controlling access to the packages saved in the database is by using SQL Server Database roles. By default, SQL Server 2005 provides the following roles for SSIS package management . You can find these by opening SQL Server Management Studio, then expanding the msdb database, Roles, Database Roles node:

?

db_dtsadmin. SSIS package administrator rights.

?

db_dtsltduser. Rights to execute only the SSIS packages the user has been given permission for.

?

db_dtsoperator. Operation rights to SSIS packages including the ability to run as well as backup and restore packages.

You can also create your own custom database roles for SSIS Package management. Add the appropriate users to those roles and then assign those roles to your own SSIS packages.

You can enable package roles using the SQL Server Management Studio by right-clicking a saved package and then selecting the Package Roles option on the shortcut menu as is shown in Figure 11

BTW, is there any reason for not using SSMS to import/export the packages (http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx)

Error deleting a folder

When we try to delete a folder in de report manager we get an internal error
from the Report server .
In the log we find:
w3wp!library!8!04/25/2007-12:46:33:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component library;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
w3wp!library!11!04/25/2007-12:46:45:: i INFO: Call to GetSystemPermissions
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to CreateFolder( 'New
Folder', '/')
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetPermissions:/
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
w3wp!library!8!04/25/2007-12:47:04:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!8!04/25/2007-12:47:09:: i INFO: Call to RenderFirst(
'/Boordtabel/dummy' )
w3wp!webserver!8!04/25/2007-12:47:10:: i INFO: Processed report.
Report='/Boordtabel/dummy', Stream=''
w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to GetPermissions:/
w3wp!library!11!04/25/2007-12:47:12:: i INFO: Call to GetSystemPermissions
w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to DeleteItem( '/New
Folder' )
w3wp!library!1!04/25/2007-12:47:12:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.RSService._DeleteItem(String item)
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[]
arguments, SignatureStruct& sig, MethodAttributes methodAttributes,
RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[]
arguments, Signature sig, MethodAttributes methodAttributes,
RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean
skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target,
Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!04/25/2007-12:47:12:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component library;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
Any ideas?On Apr 25, 6:06 am, Antoon <Ant...@.discussions.microsoft.com> wrote:
> When we try to delete a folder in de report manager we get an internal error
> from the Report server .
> In the log we find:
> w3wp!library!8!04/25/2007-12:46:33:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., un-named assertion fired for component library;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details.
> w3wp!library!11!04/25/2007-12:46:45:: i INFO: Call to GetSystemPermissions
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to CreateFolder( 'New
> Folder', '/')
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetPermissions:/
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
> w3wp!library!8!04/25/2007-12:47:04:: i INFO: Exception dumped to: C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags=> ReferencedMemory, AllThreads, SendToWatson
> w3wp!library!8!04/25/2007-12:47:09:: i INFO: Call to RenderFirst(
> '/Boordtabel/dummy' )
> w3wp!webserver!8!04/25/2007-12:47:10:: i INFO: Processed report.
> Report='/Boordtabel/dummy', Stream=''
> w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to GetPermissions:/
> w3wp!library!11!04/25/2007-12:47:12:: i INFO: Call to GetSystemPermissions
> w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to DeleteItem( '/New
> Folder' )
> w3wp!library!1!04/25/2007-12:47:12:: a ASSERT: Assertion failed! Call stack:
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item)
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
> Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()
> System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[]
> arguments, SignatureStruct& sig, MethodAttributes methodAttributes,
> RuntimeTypeHandle typeOwner)
> System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[]
> arguments, Signature sig, MethodAttributes methodAttributes,
> RuntimeTypeHandle typeOwner)
> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean
> skipVisibilityChecks)
> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target,
> Object[] values)
> System.Web.Services.Protocols.WebServiceHandler.Invoke()
> System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
> System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!1!04/25/2007-12:47:12:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., un-named assertion fired for component library;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details.
> Any ideas?
This posting might be of assistance.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ebfe917dd50ecb0c/b6c5fe0bc216e8c7?lnk=st&q=Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException%3A+&rnum=5#b6c5fe0bc216e8c7
Regards,
Enrique Martinez
Sr. Software Consultant

error creating publication

When I am in my publications folder and I attempt to add
a new publication, I get... 'Error 5: [SQL-DMO]Code
Execution exception: EXCEPTION_ACCESS_VIOLATION' after I
click next for the first time. If I click OK in the
error box, there are no publication databases listed.
HELP!!!!
Some times EM gets confused with all the caching it does.
Can you try to create the publication using the stored procedures?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:0af901c48b82$7daf3420$a501280a@.phx.gbl...
> When I am in my publications folder and I attempt to add
> a new publication, I get... 'Error 5: [SQL-DMO]Code
> Execution exception: EXCEPTION_ACCESS_VIOLATION' after I
> click next for the first time. If I click OK in the
> error box, there are no publication databases listed.
> HELP!!!!
>
sql