|
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());
}
}
}
|
|
|
|
|
Try changing:
pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
to
pkgLocation = @".\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
|
|
|
|
|
unfortunately, I came up with the same error. I just cannot understand what I am doing incorrectly. It has to be caused by something on the server somehow. I actually have the asme code in Vb and it works just fine but the c# code does not want to work past this line.
pkg = app.LoadPackage(pkgLocation, eventListener);
I have tried the following for the pkglocation,
they all give me the same error:
Failed to open package file
pkgLocation = @".\Serv37\M:\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
pkgLocation = @"\\Serv37\M:\wwwroot\AS-
MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
pkgLocation = @"\\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
pkgLocation = "\\Serv37\\wwwroot\\AS-MIS\\LoadBeaPayroll\\LoadBeaPayroll\\package.dtsx";
Any more suggestions anyone?
|
|
|
|
|
Sorry, I didn't realize that Serv37 was the server name...
|
|
|
|
|
mecca1 wrote: pkgLocation = @"\Serv37\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
try using (i.e)
pkgLocation = @"c:\wwwroot\AS-MIS\LoadBeaPayroll\LoadBeaPayroll\package.dtsx";
in local machine
if file location in other machine, make sure you have shared that path and have an access right.
dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support
|
|
|
|
|
Hi guys. ...having a little bit of trouble here. Hopefully, it's just that I'm not viewing the correct file: but here's the problem:
(.NET Framework 3.5 / VS 2008)
I have to create an "Unauthorized Access" page within one of our systems. Site navigation is handled via a NavControl on the Master Page and all pages are linked into the Master Page. To keep layouts consistent, I need to also incorporate that Master Page into the new Unauth page, which means that the other components of the Master Page are supposed to remain visible, but the Navigation needs to be hidden from an unauthorized user, save for a nav button to "Login"
However, I am having trouble accessing the NavControl programmatically within the Page_Load of the Unauth page. To access the control, I need to provide the proper ordinal to the collection
base.Master.Controls[]
but, whenever I view the designer.cs, I cannot see the Control registration order, which would mean that the ordinal that I provide would simply be a stab in the
dark.
Does Anyone know how to get this?
Does Anyone know of another way to access the control?
Note: I was able to pull the control by introspecting the Controls collection in a Debug Watch, but accessing a control via ordinal seems very pedestrian - I'm looking for something that's a little more explicitly defined than trusting that ordinal 3 will always be my NavControl. Any help?
"I need build Skynet. Plz send code"
modified on Thursday, February 5, 2009 1:38 PM
|
|
|
|
|
hi,
i need to change the visuals of the TrackBar, how do i do something like this???
do you have a snipped for me?
|
|
|
|
|
|
Hello!
For my diploma project, I must create an application that communicates with another device ( a data logger) via a Firewire connection. I chose to create this app in C# (Visual Studio 2005) , as it is the only visual development language I learned during the faculty years.
My question are:
1) How does one achieve communication through this interface? Can it be used like a normal network connection ? I noticed that in the Network Connection panel it seems to be viewed by Windows like a normal connection....
2) The data logger doesn't understand the TCP/IP protocol ( only Network Layer 2 ...). The app should basically receive huge amount of data from the logger, and it should also send some command packets. What I need to do is analyze every packet that comes from the logger , and store it, but it is difficult because of TCP/IP being not supported. Can i use the WinPCap / SharpPCap dll's for raw packet manipulation ? If not, can someone please tell me how do I access the raw packets that are received / sent by the FireWire? Is there such a dll?
Thank you in advance!
George
P.S. Sorry for my English... i learned it from cartoons
|
|
|
|
|
I have created a setup file in windows application and then i installed it in my system only. After giving userid, password for authentication from the database,even if the userid and password is contained in the database, i am getting the exception "System.Data.SqlClient.Sqlclientpermission,system,.........,publickey token='......' failed"
|
|
|
|
|
you mean your putting username/password in connection string? if so you need to set up database on server with useraccount that matches those value, does not matter if they stored in any table
My opinion is... If someone has already posted an answer, dont post the SAME answer
|
|
|
|
|
I think there's something wrong in the security settings. Are you sure that SQL Client is placed in GAC? Also do you start your program from trusted folder? SQL Server Client needs pretty much privileges.
|
|
|
|
|
My project is a windows application. After i install the setup file of this project. I am getting the first form, i need to select from four options i,e. four buttons. When i press a button, next form is displayed asking for username and password. After giving username and password, when i press login button then i am getting that exception. If i run normally in visual studio 2005 , it is executing .
|
|
|
|
|
Good day helpers
I'm not sure how to embedded my code to a PDA.
|
|
|
|
|
Pardon?
Regards,
Rob Philpott.
|
|
|
|
|
I'm craeting a prafic system as my third year project. Now I want to embedde that code in my PDA device.
|
|
|
|
|
I meant a trafic not profic
|
|
|
|
|
PDA is a Personal Digital Assistant that a person can use as a portable computer. Do you get me?
|
|
|
|
|
We get you, we just don't know WTF you need help with... did you start coding at all? Where is your error?
|
|
|
|
|
When they talking of a lumpan they discribe ppl like u
|
|
|
|
|
Go learn English, you have a better chance of passing then you do of coding.
|
|
|
|
|
|
Don't forget, you fail.
Next time you want work done for free, go to class or better yet, support real programmers and go to this site[^] so at least the people who contracted to you get something for their money, jerkoff.
|
|
|
|
|
Member 3916856 wrote: PDA is a Personal Digital Assistant that a person can use as a portable computer.
My god, If only I had known that earlier. That makes everything clear. A portable computer, YES! Like... like a Nintendo gameboy?
|
|
|
|
|
Ja its more like that, I haven't started my code. I was wondering if is there any material that u guys can provide. Or where i can get hepl from. Thnx
|
|
|
|