Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HalaszJ
Yak Posting Veteran
59 Posts |
 Posted - 2008-08-27 : 15:54:44
|
| Are there any samples out there on how to do a wmi query into a sql table using a scheduled SSIS job?I have looked everywhere... I have a vbs script that I used to input the data into an excel doc, but now the data has grown to a point where I want to put it in the database so that I can do reporting on it... any ideas? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-27 : 16:54:05
|
maybe create a CLR proc that makes the WMI query?
elsasoft.org |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
HalaszJ
Yak Posting Veteran
59 Posts |
Posted - 2008-08-28 : 08:38:05
|
| i dont need wmi to import from excel, my current project imports from wmi to excel, i want to import from wmi to sql |
|
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2010-05-10 : 14:32:41
|
| Do you have an example of that Excel project? I can convert it to SQL~ Shaun MerrillSeattle area |
|
|
|
|
|
|
SSIS WMI Job?