|
Hi all i am trying to execute a SSIS package from C# code the code is like this..
Application app = new Application();
Package package = app.LoadPackage("d:\\Main.dtsx", null);
package.ImportConfigurationFile("d:\\Main.dtsConfig");
try
{
DTSExecResult result = package.Execute();
}
but it not giving the desired result...
can anybody help me here to getin the problem..
Thanks in advance...
T@SU
|
|
|
|
|
tasumisra wrote: but it not giving the desired result...
Why not? What is happening?
Unless you provide specific details of your problem, i.e. error information, no one is going to be able to help you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
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());
}
}
}
|
|
|
|
|
Hi,
How can I limit the number of digits entered into the cells of a column in datagridview?
For example, in column 10 of the datagridview, I would like users to be able to enter up to 8 characters.
Thanks
|
|
|
|
|
How to download attachment from POP3 mail?
i have problem of finding attachment in a mail from pop3 server and saving the attachment from mail in to my local drive please help me to resolve the issue...
|
|
|
|
|
hi
take a look at these articles[^] there are some good pop client libs around..
greets
m@u
|
|
|
|
|
I have created given below method which saves xml file and passes xml file name to database through client but there is an error message::::
which states like this::Server was unable to process request. ---> Cannot open database "client_server" requested by the login. The login failed.
Login failed for user 'WLINKCOMP3\ASPNET'.
wlinkcomp3 is the comp where web service is residing.......
[WebMethod]
public void ret_xml(XmlDocument file, string file_name)
{
int hi = 0;
string total_file_name = "Client_Information_" + file_name+".xml";
string path_image = "images/" + total_file_name;
file.Save(Server.MapPath(path_image));
thisConnection = new SqlConnection(connection);
SqlCommand myCommand = new SqlCommand("SELECT * FROM client_name", thisConnection);
thisConnection.Open();
myCommand.ExecuteNonQuery();
rdr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (rdr.Read())
{
string present = rdr["client_name"].ToString();
if (present == file_name)
{
hi = 1;
}
// thisConnection.Open();
}
rdr.Close();
if (hi == 1)
{
SqlCommand myCommand1 = new SqlCommand("INSERT into client_name(client_name) values ('" + file_name + "') ", thisConnection);
myCommand1.ExecuteNonQuery();
}
thisConnection.Close();
}
now given below is the client part
which generates xml files and passes the file name to web server....
Service aaa2 = new Service();
aaa2.ret_xml(xml_doc, StrFileName2);
could anybody help me...
thanking in advance 
|
|
|
|
|
You need to set up a user account for the ASPNET machine account (WLINKCOMP3\ASPNET) in your SQL Server and grant it the appropriate level of access to your database.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
I have a custom Form.Region value of my forms. It works correctly under WinXP or Vista but there is some issue under Windows 2000. It's shifted somehow...
I wasn't able to google it fast enough so if any1 has an answer please
thak you!
zilo
|
|
|
|
|
hi,
i've got this kind of a simaple xml :
<br />
<?xml version="1.0" encoding="iso-8859-1"?><br />
<App_Data><br />
<App_DB>IMSS_HMI_DB</App_DB><br />
<Fail_DB>NEW_DB</Fail_DB><br />
<Station1_Port_Number>1000</Station1_Port_Number><br />
<Station1_IP_Number>100.100.100.37</Station1_IP_Number><br />
<Station2_Port_Number>1000</Station2_Port_Number><br />
<Station2_IP_Number>192.0.0.1</Station2_IP_Number><br />
<Station3_Port_Number>1000</Station3_Port_Number><br />
<Station3_IP_Number>192.0.0.1</Station3_IP_Number><br />
</App_Data><br />
<br />
i like to read/write from/to a specific elenet string Lets say :Station2_IP_Number
Can anyone give me an Example?
i did tried xtrApplicationData.ReadElementString
but with no success
THANKS
Have Fun
Never forget it
|
|
|
|
|
XmlDocument doc = new XmlDocument();
doc.Load("c:\myXML");
XmlNode node = doc.SelectSingleNode("//Station2_IP_Number");
MessageBox.Show(node.InnerText);
node.InnerText = "whatever";
doc.Save();
Something like that. Read up on XPath and the XmlDocument class.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
TANKS A LOT
Have Fun
Never forget it
|
|
|
|
|
In .NET, have a look at the System.Xml namespace.
You can use XmlDocument.Load() to read your document in, and XmlNode.SelectSingleNode() to find the element you are looking for using XPath (such as "//Station2_IP_Number"). XmlElement.InnerText will get you to the content of that node.
For reference, look up System.Xml on MSDN, and try http://w3schools.com for help on stuff like XPath.
|
|
|
|
|
Hi,
correct me if I'm wrong but I don't think that you can change anything with XML reader/writer. It is a one way mechanism of reading/writing text formated in XML style. Only way how to do that is to use a reader to read the elements and implement some logics to write same or different value depending of what you want...
Example:
using (XmlTextReader reader = new XmlTextReader("C:\\books.xml"))
{
while (textReader.Read())
{
Console.WriteLine("Name[{0}] Type[{1}] = Value[{2}]", reader.Name, reader.NodeType, reader.Value);
}
}
Easiest way and probobly the slowest (to get some hierarchy) is to use the XmlDocument class, find apropriate node and change it's value. It depends on how big you suppose the xml text will be...
zilo
|
|
|
|
|
THANKS
Not Big,
Maybe 7 Atrr
The purpose is to let Setup.ini File "DIE"
and start using xml (Because .Net C# support XML but not Ini)
if u realy want to use ini, u need to use system32.dll do extract the method and so on...
Have Fun
Never forget it
|
|
|
|
|
hi,
I have allowed the users to enter data into the cells of one column only.
This is a price column so only prices can be entered. i.e. 123.4322 and no alphabets.
Do I validate the cell in _cellvalidating or _cellvalidated or cell_Leave events? If so, how do I do this please?
Thanks
|
|
|
|
|
Do it in the "validating"-event
|
|
|
|
|
|
The size of an empty class is 1 byte but it may be different 2 or 4 on other OS.
m i right
correct me if i'm wrong
|
|
|
|
|
To be ernest: I don't know but I doubt it (why do you need to know?) - but you can use the Marshal.SizeOf method to find out.
|
|
|
|
|
|
Ok:
<br />
<br />
class App<br />
{<br />
public static void main()<br />
{<br />
System.Console.WriteLine("empty class has " + <br />
System.Runtime.InteropServices.Marshal.SizeOf(typeof(Empty)).ToString() + <br />
" bytes.");<br />
}<br />
}<br />
<br />
class Empty<br />
{}<br />
<br />
Please refer to the help for more info on Marshal!
|
|
|
|
|
Friend it's throwing the following error
Type 'Empty' cannot be marshaled as an unmanaged structure; no meaningful size or offset can be computed.
|
|
|
|
|
Sorry - didn't try - seems the compiler just skips the Empty class.
|
|
|
|
|
Does not matter....
Can u let me one another question.....
Total Namespaces and Classes supported by .NET Framework
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
