I am trying to run DTS Packages through VB .NET. Each
time I attempt to run the package I get the following
error: "Cannot find specified package in the storage
location specified. Error -2147220460 (80040414)."

I have: updated all instances to sp3; reordered the
switches(/E /M /G /F) to be in the same order as
discussed in the dtsrun help and decreased the spaces
between switches to no avail. I have also attempted to
run the package by initiating a process for dtsrun in the
application, imported the dtspackage reference and
executed as a new dts.package and executed the package
through the commandline without success.

The package does exist. Does anyone have any
suggestions? What am I missing? Thanks for your help.

SCS

Can you show us the part of your code where you load the package up ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"SCS" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I have resolved this issue by taking some advice from another thread. I simplified the code by eliminating the /G switch and saving the dts package under a new name to eliminate multiple versions. As for the code, below I show a sample of the code I execute within a VB program. "proImportData" is declared as a new process. I am now able to execute without error

strDTSArgument = "/E /M" & quotes & "*********" & quotes & " /F" & quotes & ProgramPath() & "\IRIS\RAG Data\DTSPackages\Import RAG Data.dts" & quote

With proImportData.StartInf
.FileName = DTSPat
.Arguments = strDTSArgumen
.UseShellExecute = Tru
.CreateNoWindow = Fals
.ErrorDialog = Tru
.ErrorDialogParentHandle = Me.Handl
End Wit

proImportData.Start(
proImportData.WaitForExit(

Thank

SC