Permissions problems loading DTS file in C#

From: Paul Enfield (penfield_at_paraport.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 15:11:16 -0800

I'm using the code sample provided at
http://SQLDev.Net/DTS/DotNETCookBook.htm to attempt to load a .DTS package
in C# through the COM Interop services, and execute it.

When the LoadFromStorageFile method is called I get the following error:

System.Runtime.InteropServices.COMException (0x80040414): Cannot find
specified package in the storage location specified. at
Microsoft.SQLServer.DTSPkg80.Package2Class.LoadFromStorageFile(String
UNCFile, String Password, String PackageID, String VersionID, String Name,
Object& pVarPersistStgOfHost) at ExecPkg.App.Main(String[] args) in
h:\test\dts cookbook\execpkgcs\execpkg.cs:line 32

Initially I was getting a nondescript security exception but worked around
it by setting the .Net Framework Runtime Security Policy/Machine/Permission
Sets to FullTrust.

Thus far I have also tried:
- Granting full ACL's to the file to Everyone at both the domain level and
the local machine level.
- Using explicit path references
- Using UNC reference
- Placing the file local to the executable
- Placing the file on a remote network drive
- Placing the file on the SQL Server itself
- Enabling file auditing, and setting up Failure Audit's on the .DTS file
(nothing triggered... not entirely sure I did this right =^| )

Any pointers appreciated.

Relevant Pages

  • Re: DTS and stored procedure
    ... The DTS package can be stored in the Microsoft® SQL ... > Displays the command prompt options. ... > of the command used to execute the DTS package because the server name, ... Specify server_name to ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... When you execute a DTS package it comes to you. ... The job will execute on the server itself. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • How can a non-owner start a job?
    ... There is a DTS package scheduled for execution every night as a SQL Server ... "Execute permissions default to the public role in the msdb database. ... who can execute this procedure and is a member of the sysadmin fixed role ... A user who is not a member of the sysadmin role can use ...
    (microsoft.public.sqlserver.security)
  • DTS export data from Sqlserver to MDB
    ... I setup a DTS package to export a table from sql server to microsoft acess ... Z:\Payment ... I can execute the DTS package from Enterprise Manager but I want to allow my ...
    (microsoft.public.sqlserver.dts)
  • DTS FTP & Scheduling
    ... I created a simple DTS package which uses the FTP task in Enterprise ... I want to get a file off of the SQL Server D:\ Drive and copy ... When I manually execute the job it runs ... DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress: ...
    (microsoft.public.sqlserver.dts)
Quantcast