|
Hi all, i have a problem with job scheduling...
I have a ssis package (2 actually)... i need this package to loop over and over again. (this package monitors a folder on a server and waits for a specifiec file type before reading the values in that file into the database and formatting the data and ultimately creates a new file with the same name, replacing the old file). Currently i have 2 packages doing this one job... each package ends with a "Execute Package" task. So, Package A would execute Package B at the end and then Package B would execute Package A at the end. (this puts my Job in an infanite loop, which is what i wanted...) BUT now i noticed that each time the package executes the next package, the "Running Packages" (as seen when you log onto the "Integration Services" on the server in SQL Server 2005) gets one extra package... (i presume this takes up memory). So this can't be good in the long run.
So what i need help with is the following...
1. I need to put both packages into one package. (i know how to do this.)
2. I need to schedule the package in a job to execute every time the job ends successfully.
I need help with the number 2 please... i dont know how to schedule a job to execute as soon as it successfully ended???
Thank you in advance. (any suggestions will be greatly appreciated.)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
Is this a question about VB or SQL Server 2005?
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
So sorry, i thought i clicked on the sql link...
my appologies...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
HI
I AM IN POSITION TO FIND PRESENCE OF UNIQUE STRING(ALL ARE FILE NAMES) FOR THAT I AM PLANNING TO USE REGEX SEARCHING COULD. ANY SAY WHICH WILL BE BETTER ONE REGEX OR ARRAYLIST.BINARYSEARCH OTHERWISE ANY OTHER GOOD SERCHING TECHNIQUES .COUNT OF NAMES WILL BE MORE THAN 15K SO COULD ANY ONE SUGGEST WHICH ONE I SHOULD USE.
with regards
Balagurunathan.B
|
|
|
|
|
1. Stop SCREAMING!
2. Rewrite your question and try to separate it into proper sentences.
These two steps will give you a better chance of someone reading the question and actually concentrating on the issue instead of how hard it is to try to read what you have written.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
hello everybody!
I want to create menu in my project as auto hide window just like
properties window in visual studio.NET.If someone has idea about this , pls share ur idea.
phoo pwint
flowerppk
|
|
|
|
|
You can probably use third party control like DotNetMagic
|
|
|
|
|
I'm currently creating an application for our helpdesk to assist in trouble shooting. I work for a Native American tribe and we have field offices spread out in the Southeast corner of Oklahoma, and we get a lot of calls from people who are not real computer savvy. The application will be installed on the user's computers that are outside of our domain (we have set up a policy in our AD to place a background on the domain user's computer to display their network information). Currently I have the application displaying the user name, the ip, and network connectivity, but I would like to have it be able to release and renew the ip address since that is sometimes the most difficult thing to walk people through over the phone.
Is there any simple way to do this?
|
|
|
|
|
Hi Dave,
I dare not say that this is the best way, but it may work for you:
<br />
Public Function ExecuteDosCommand(ByVal cmd As String)<br />
'activate dos<br />
AppActivate("C:\WINNT\system32\cmd.exe")<br />
'send the command (for example: "ipconfig /release")<br />
SendKeys.Send(cmd & vbCrLf)<br />
'Flush the buffer, just for safety<br />
SendKeys.Flush()<br />
cmd = ""<br />
End Function<br />
The path to cmd.exe may not be correct, but I am sure you'll figure it out.
Hope it helps,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
How about :-
Public Sub RenewIP()<br />
process.start("ipconfig /renew")<br />
<br />
End Sub
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
So I was right not to dare claim that my way was the best 
I didn't know about this one. However this function asks for a file name. In your example you pass the dos command straight to the function though. Will it not throw a "file not found" exception?
My advice is free, and you may get what you paid for.
|
|
|
|
|
Yes you are right, so replace the Process.Start with :-
Shell("IPConfig /renew", AppWinStyle.NormalFocus, True)
For belt and braces you could try :-
Private Sub RenewIP()<br />
Dim sCommand As String = System.Environment.SystemDirectory & "\IPConfig.exe /renew"<br />
Shell(sCommand, AppWinStyle.NormalFocus, True)<br />
End Sub
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
So Dave, instead of my answer to your problem, I advise you to use the one Steve suggested in his answers to my reply.
My advice is free, and you may get what you paid for.
|
|
|
|
|
First of all, thanks for all the help. Now, I showed the completed app to the rest of the guys in IT and we came up with the idea of showing the subnet mask and the default gateway (Maybe the MAC, but we really haven't decided). I've found some code calling a WMI, but I can't seem to get it to work right.
Any suggestions?
|
|
|
|
|
Aptiva Dave wrote: but I would like to have it be able to release and renew the ip address since that is sometimes the most difficult thing to walk people through over the phone.
Is there any simple way to do this?
Very easy. You don't even need to write any code. Just create a batch file and use this:
%systemroot%\system32\ipconfig /release
%systemroot%\system32\ipconfig /renew
Call the file iprenew.cmd and drop the file in the C:\Windows folder. When the user needs to renew their IP address, just tell them to click on Start, then Run, and type iprenew and hit Enter.
|
|
|
|
|
The main issue with creating this app is because we have noticed throughout the years that our users just are not that comfortable with using the command prompt. They are very visual people. I also put into this app their computer name and their user name, along with a function to ping an outside address (right now yahoo.com) to test whether they are connected to the internet. Hopefully it should save us some time.
|
|
|
|
|
i know this is waaaay old but here's a cleaner ".Net version" anyway
Public Sub ReleaseIP()
Process.Start(System.Environment.SystemDirectory & "\IPConfig.exe", "/release")
Sleep(3) ' 3 Seconds to give ipconfig time to finish
End Sub
Public Sub RenewIP()
Process.Start(System.Environment.SystemDirectory & "\IPConfig.exe", "/renew")
Sleep(3) ' 3 seconds to give ipconfig time to finish
End Sub
|
|
|
|
|
I am already finish my VB.net project, but I want to protect my project with like CD key, so people can not use my project if they do not know the key.
The problem is I dont know how to make the key.
May someone help me please?
|
|
|
|
|
There's no one set way of doing it.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Winarto wrote: The problem is I dont know how to make the key.
"THE" key? Think about that now. What's to stop anyone from just writing down "THE" key and sending it with every copy of the CD they make??
|
|
|
|
|
I am already finish my VB.net project, but I want to protect my project with like CD key, so people can not use my project if they do not know the key.
The problem is I dont know how to make the key.
May someone help me please?
|
|
|
|
|
Hi,
In reference to your query I would like to mention that there are some common techniques used to design CD or software Keys.
Some common techniques are just to use random math stuff. So lets say you have a serial like this: XXXX-XXXX-XXXX-XXXX
You could randomly generate numbers (either decimal or hex format), for the first 3 groups. Set Group # 4 to the answer of (Groups 1 and 2) / Group 3. You could add random constants or do other funny things.
Another technique is to randomly generate what cryptologist call a "salt". So using the same format as above, you would randomly generate group #1, concatenate the "salt" with some other string that you hard-code, and then put that whole string through an md5 (or other) one-way hashing function. Then the remaining 3 groups can be some defined portion of the md5 hash. Sometimes companies require the buyer to "telephone activate", where they have to give their name, and then the company name to generates them a serial using their name as a salt to some serial generator. In this way the user's information is slightly more tied into the whole scenario. If you want to take it one step further, use their credit card number as the salt, this will make them more unlikely to just share their activation information with others.
I hope this would help to initiate the things. For code snippets you may search on Google.
Have a nice day  .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Try not to post the same question twice. Looks like you might have double clicked on submitting.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
A class was created, and objects added to a listbox to form an arraylist.
Ojects were added to arraylist as in
Dim item As items
For Each item In form1.Arraylistlist
Me.Listbox1.Items.Add(item)
Next
How can I delete an object from the arraylist when displayed in Listbox1?
|
|
|
|
|
Hi,
you can add and remove items to/from any collection using the appropriate methods,
see documentation.
However, when you try to modify a collection while you are enumerating it (as in
a for each), you will get an exception.
There are many remedies:
- don't use for each in this case, use a for or a while loop
- create a Clone of the list for the enumeration
- use a temporary collection to remember which items will have to be deleted afterwards
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
