|
I want to design SSIS component when i load the package.
My goal is to reproduce the components contained in a package when I load it.
The package is loaded by c# , winform application , i can load package ( doc.LoadXml(packageXml))
When the xml is loaded, I retrieve the layout of the package and its components. . With the layout, I can get the coordinates of the component and redraw one by one.
well that's what I think.
This link
http://pragmaticworks.com/Products/BI-xPress/Features/SSISMonitoringConsole.aspx ,
picture 3 and 4 show what I would like to have as result.
This example concerns the 2012 packages
Also the picture 3 of the following link shows the result of thepackages in 2008 and 2005
https://ssisloganalyzer.codeplex.com/
Thx for any Help.
|
|
|
|
|
I need to put 2 copies of the same dataset on a form. Then I can bind my 2 grids to one copy each and I can then supply different parameters to each dataset on the fill. I can't figure out how to get the second copy of the dataset onto the form... can someone advise please?
Thanks.
|
|
|
|
|
I think datasets have a method that's called copy and clone. see here[^] it effectively takes a deep copy of the object.
hope this helps.
|
|
|
|
|
Hi everyone,
I have xml string like this:
<content>
<person>
<firstname>Peter</firstname>
<lastname>John</lastname>
</person>
<person>
<firstname>Tom</firstname>
<lastname>Crui</lastname>
</person>
<person>
<firstname>Holse</firstname>
<lastname>Moul</lastname>
</person>
</content>
Now I want to get the node <firstname> that has value: Tom
Do you know how can do that (I don't want to use a for/foreach statement to check)
Thanks and regards,
Tai
|
|
|
|
|
|
I want the simple code for display the waveform
JOHN
|
|
|
|
|
johnsamuel26 wrote: I want To ask a proper question. It is far from clear what your problem is, and it is unlikely that anyone is going to provide the code for you.
Use the best guess
|
|
|
|
|
See here[^] then come back and update your question. (don't create a new one)
|
|
|
|
|
Hello all,
Looks like this is a basic question that I somehow is not able to figure it out properly. The method I am using works for Hex numbers that does not contain 0 in its lower byte.
I guess I have to use a different approach to get around this problem, which I am not able to quite figure it out.
I am reading values off of an IC which pushes out serial data in bits and the total length of the output is always 16bits which are read into two bytes. So, when the value is 255 its fine when I convert it into integer. But when the output from the chip is equivalent to 256, it turns out to be '1' in Upper byte and '0' in lower byte which is not being converted to 256 but rather to 16 using the following code.
string hexValue = In[0].ToString("X") + In[1].ToString("X");
int hscandacvalue = int.Parse(hexValue, System.Globalization.NumberStyles.HexNumber);
Any suggestions?
thanks
PKNT
|
|
|
|
|
The problem with this is that it turns eg 0x01 (as a byte) into the string 1, and then the leading zero is lost. That's a problem, because you're concatenating in front of it. You could fix that by using X2, but don't.
But you don't need any of this weird string business anyway, you can simply use math (lowbyte + 256 * highbyte )
|
|
|
|
|
Thanks Harold, that works great.
PKNT
|
|
|
|
|
hi folks,
i want a general idea of how to create a server-client environment in window application(c#.net). So what i am looking for is:
1. A sample mini project so far none found on google
2. what technology should i use udp/tcp/socket layer or something else.
3. how does client A gets notification of SQL update by client B ;when both are viewing/working on same table. So the record can get an auto refresh or something like that.
Regards
|
|
|
|
|
Don't make this too hard. I wrote one a few years ago and started like you are. I wanted PC-A to tell everyone else that it had just made a change.
But the easy was is for each pc to monitor the db and find the changes on it's own. You don't need any network code to handle that. For me it could be a few minutes behind so it worked great.
|
|
|
|
|
|
are you sure big DB data can travel through sockets ??
|
|
|
|
|
Any type of data can travel through sockets; how do you think the internet, database systems etc work?
Use the best guess
|
|
|
|
|
can you re-create the given sample for a simple test table in sql, yesterday one of my friends told me to just share connection string path to server as one approach to do the thing ; But will it be on the same performance with socks?
|
|
|
|
|
Alok sharma ji wrote: will it be on the same performance with socks? There's only one way to find out.
Use the best guess
|
|
|
|
|
|
Manfred, have you ever used the notification service, I know we have never had to implement it and I am curious.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I know we have never had to implement it and I am curious.
I have been exclusively doing backend database driven stuff often in high demand environments and the only 'need' I have ever seen for this is when some developer claims that it "could" happen. Analyzing actual business cases and actual usage has never demonstrated a need.
|
|
|
|
|
That has been my experience except I'm the developer so it has never happened, every now and then I have to slap a BA who suggests it to the users.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Indeed I always heard the rumors of SQL notification to subjugate LAN as RTS but caching one is like "fools gold".
|
|
|
|
|
Alok sharma ji wrote: 3. how does client A gets notification of SQL update by client B ;when both are viewing/working on same table. So the record can get an auto refresh or something like that. That's usually not done; the normal way is to fetch the data and show the snapshot as it was on the moment of fetching. Updating "live" data moves the concurrency-problem from the database (where it was solved) into your app, where you need to solve it yourself.
Simple example; you're editing a record, and the boss is editing the same one - you press "update" first. Now, how would you update the bosses record? Change the text in the textbox while he is editing/typing?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
i think i will just put an edit lock for client 2 if client 1 is working on same table.
|
|
|
|