Click here to Skip to main content
15,910,009 members
Home / Discussions / C#
   

C#

 
JokeRe: regarding to dll hell with code Pin
Luc Pattyn11-Dec-07 4:15
sitebuilderLuc Pattyn11-Dec-07 4:15 
GeneralRe: regarding to dll hell with code Pin
creative2002guy11-Dec-07 7:09
creative2002guy11-Dec-07 7:09 
GeneralEnterprise Library configuration tool Pin
PaulPrice11-Dec-07 2:19
PaulPrice11-Dec-07 2:19 
Generaldatatable column size Pin
arkiboys11-Dec-07 1:55
arkiboys11-Dec-07 1:55 
GeneralRe: datatable column size Pin
pmarfleet11-Dec-07 2:47
pmarfleet11-Dec-07 2:47 
Generalerror in execution of SSIS package.. Pin
tasumisra11-Dec-07 1:05
tasumisra11-Dec-07 1:05 
GeneralRe: error in execution of SSIS package.. Pin
pmarfleet11-Dec-07 2:48
pmarfleet11-Dec-07 2:48 
GeneralRe: error in execution of SSIS package.. Pin
mecca15-Feb-09 7:17
mecca15-Feb-09 7:17 
The following is the exact message I am getting when running the application from Visual Studio 2005, trying to load a .dtsx package. I could not add a screen shot here. The code is so simple that I cannot understand what the path problem is.

Failed to open package file "\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

The. ,dtsx package and code are both located on the server. I can run the .dtsx package fine in BIDS and get the required result. When the code runs to the line "pkg = app.LoadPackage(pkgLocation, eventListener);" that is when I get the "Failed to open package file" error.

Below is a re-posting of the actual code:

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.SqlServer.Dts.Runtime;

namespace DocBeaEntry
{

class MyEventListener : DefaultEvents

{

public override bool OnError(DtsObject source, int errorCode, string subComponent, string description, string helpFile, int helpContext, string idofInterfaceWithError)
{

// Add application-specific diagnostics here.

Console.WriteLine("Error in {0}/{1} : {2}", source, subComponent, description);return false;
}

}

public class clsSSIS

{

public static void RunDTSX()
{

string pkgLocation;
Package pkg;

Application app;
DTSExecResult pkgResults;

MyEventListener eventListener = new MyEventListener();
pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";

app = new Application();

pkg = app.LoadPackage(pkgLocation, eventListener);

pkgResults = pkg.Execute(null, null, eventListener, null, null);Console.WriteLine(pkgResults.ToString());
}

}

}
Generaldatagridview cell size limit Pin
arkiboys11-Dec-07 0:31
arkiboys11-Dec-07 0:31 
GeneralPop3 mail attachment download Pin
energeticsridhar11-Dec-07 0:18
energeticsridhar11-Dec-07 0:18 
GeneralRe: Pop3 mail attachment download Pin
m@u11-Dec-07 2:10
m@u11-Dec-07 2:10 
Generalunable to find database of webservice Pin
Member 447840010-Dec-07 23:53
Member 447840010-Dec-07 23:53 
GeneralRe: unable to find database of webservice Pin
pmarfleet11-Dec-07 2:31
pmarfleet11-Dec-07 2:31 
GeneralCustom Form.Region under Win 2000 Pin
Stevo Z10-Dec-07 23:51
Stevo Z10-Dec-07 23:51 
GeneralXML Reader/Writer Pin
half-life10-Dec-07 23:48
half-life10-Dec-07 23:48 
GeneralRe: XML Reader/Writer Pin
Christian Graus10-Dec-07 23:57
protectorChristian Graus10-Dec-07 23:57 
GeneralRe: XML Reader/Writer Pin
half-life11-Dec-07 0:05
half-life11-Dec-07 0:05 
GeneralRe: XML Reader/Writer Pin
andypaxo10-Dec-07 23:59
andypaxo10-Dec-07 23:59 
GeneralRe: XML Reader/Writer Pin
Stevo Z11-Dec-07 0:30
Stevo Z11-Dec-07 0:30 
GeneralRe: XML Reader/Writer Pin
half-life11-Dec-07 1:20
half-life11-Dec-07 1:20 
Generaldatagridview cell validation Pin
arkiboys10-Dec-07 23:44
arkiboys10-Dec-07 23:44 
GeneralRe: datagridview cell validation Pin
CKnig11-Dec-07 0:25
CKnig11-Dec-07 0:25 
GeneralRe: datagridview cell validation Pin
arkiboys11-Dec-07 0:32
arkiboys11-Dec-07 0:32 
Generalsize of an empty class Pin
.NET- India 10-Dec-07 23:26
.NET- India 10-Dec-07 23:26 
GeneralRe: size of an empty class Pin
CKnig10-Dec-07 23:28
CKnig10-Dec-07 23:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.