SQL Server Performance Forum – Threads Archive

WMI to SQL Server

I want to know if there is any way we can redirect all the outputs from WMI script/ VB Script into SQL Server database. Can any one please comment how this can be achieved. Or is there any way we can run WMI Scripts from SQL Server Feel free to post any questions on this.

---

If you store the result of WMI script/ VB Script as Text file, then you can try bulk insert table from ‘FilePath’
WITH (
DATAFILETYPE = ‘char’,
FIELDTERMINATOR = ‘ ‘,
TABLOCK
) Madhivanan Failing to plan is Planning to fail

---

Isn’t there any other direct way of connecting to SQL Server instad of saving it into a notepad and running a DTS. Thanks

---

Create a standard ADO connection in your vbscript to connec to to sql server. Google for Server.CreateObject("ADODB.Connection")

---

]]>