Re: Unable to delete a package
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 13 Jan 2007 10:23:16 +0000
You have the RemoveFromSqlServer method on the Application class that will do this
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/M_Microsoft_SqlServer_Dts_Runtime_Application_RemoveFromSqlServer_2_9f8a5808.htm)
But I am not sure that this will help you. What permissions do you have in SSIS? To which roles do you belong? How was the package saved (ProtectionLevel)? Is it one of your packages?
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com
"AOTX San Antonio" <ElTejano@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:27820C94-9194-4041-9DB2-4D6409BF0458@xxxxxxxxxxxxx:
While learning SSIS I saved several packages to the Server...I have always
been able to delete these packages until now. I have one package that I
cannot delete. I have checked the web to see if anyone else has seen this
problem but have yet to come across a solution. The error I receive is as
follows:
Dialog box Title is Object Explorer
Access to Integration Services package 'Package Name' is denied. (Microsoft
SQL Native Client)
Additional information:
Repeats the same message as above "Access to ...
Is there another way to delete this package other than by right clicking on
the package and selecting the menu option "delete"
Thanks
.
- Prev by Date: Re: why my asp script failes to process DTS with access database connection?
- Next by Date: Re: SQL DTS 2005 to 2000
- Previous by thread: Re: SQL DTS 2005 to 2000
- Next by thread: Copying SQL Server Object Tasks
- Index(es):
Relevant Pages
|
Loading
