February 11, 2008 at 9:33 am
Hi.
I want to create a SSIS package that first reads a .txt file where a lot of hosts (machine names) are listed.
While reading the file I want to ping all the computers listed in the file and insert the result into a MS SQL 2005 database.
Also I want some other information such as:
IP Address, OS version, Time for ping task.
If one or several computers doesn't answer I have created another table where that machine name are inserted into.
If the machine answers the date from the last time it was "pinged" must be overwritten by the new date.
can any one help me out with this??
Best regards Jan.
February 11, 2008 at 11:45 am
Sounds to me like "wrong tool for the job". Meaning - SQL Server is really not designed to do that, and while it CAN be tortured into doing it, there are lots of better tools that could do it with a lot fewer headaches.
Personally - I'd look at a .NET console app which then dumps/updates a table in SQL with its results. Would be much simpler, cleaner and quite honestly a better use of the resources (usually your SQL server has "better things to do with its time".)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 11, 2008 at 7:29 pm
I'm thinking a simple looping DOS batch file would work just fine... either that or maybe a simple VB script.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply