tags:

views:

30

answers:

1

I have created a .NET application designed to use the RemoveFromSQLServer function to delete DTS packages from a SQL server. This is the entirety of the code:

Sub Main()
    Dim app As New Application
    app.RemoveFromSqlServer("dts_rob_temp", "MyServer", Nothing, Nothing)
End Sub

When I try to run it, I get the below fairly undescriptive error:

An error was encountered when trying to remove the package "dts_rob_temp" from SQL Server.

The package exists, the server is being specified correctly, and it is getting past the login, because by changing the login variables, I am able to get a login error.

A: 

Sorry to ask the obvious, but does the account have permissions to delete the object?

tbs