May 26, 2008 at 10:53 pm
Hi.
I have a question regarding SSIS and ping.
I know its possible to ping all hosts in a OU using vb script, but does anyone know if its possible using vb.net in SSIS as a script task and insert the result into a MS SQL 2005 database and also how?
The only result I'm interested in is "relpley from ipaddress" and the hosts that does not answer could insert a value like "host not responding".
Today I'm using C# but it seems a bit slow (possible bad development) but I'm hoping to improve the speed using SSIS.
Regards Jan.
May 27, 2008 at 12:48 am
Hey Jan,
Anything you can do in vb .net you can invariably do in SSIS vb .net, all about importing the correct library (or so my resident .net guru assures me - take note, this dude is my lifesaver, without him, I wouldnt be able to script half the stuff).
Imports System.Net
Gives you quite a bit of flexibility.
If you post a sample of the ping script that you have, then we could see if we could assist with a scripting task
~PD
May 27, 2008 at 5:55 am
Hi.
Well, my setup is as follow:
1: using a "Execute Process Task" which executes a .bat file where I'm using ADfind to get a list of all active hosts in our OU:
adfind -b "OU=XXX,OU=XXX,OU=XXX,DC=XXX,DC=XXX,DC=XXX" -f "&(!(useraccountcontrol=4130)(!(useraccountcontrol=4098)))" "dnshostname" -list > C:\mfgHosts.txt
And pipes the result into a .txt file.
2: The information in the .txt file is then exported info a MS SQL 2005 database.
3: Then I've ping all the hosts and collect some system information using WMI and add the data to each host.
The Ping class that I've have been modifying is an example I've found while searching the Internet - but here is the original one.
My problem is when I try to ping all the hosts - about 500 and some of the hosts that are not Online, but their IP address is visible because of DNS it just keeps trying to ping that specific host and the application stops.
Thats why I would like to try to do the "ping part" in SSIS and inserts the result to the database and just use my application to collect the system information.
But if your or anyone else have some idea how to increass the speed regarding the DNS problem that would be fine.
If you need more information just let me know.
\Jan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply