Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dave Lumley » SSIS & WMI Data Reader Task Query
Add to briefcase
30 posts, Page 3 of 3
«««123

SSIS & WMI Data Reader Task Query Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
dave-dj
Posted Friday, May 27, 2011 8:34 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014
try downloading the WMI code creator:

It will help you write the queries you need to retrieve the data your after.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2CC30A64-EA15-4661-8DA4-55BBC145C30E

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1116293
rdeheld-535532
Posted Wednesday, August 03, 2011 3:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:18 AM
Points: 18, Visits: 304
Hi great article Just modified it a bit to get a inventory via WMI of all the Physical Processors instead of cores, works great and added it into the DBA_MORNING_CHECKS ssis package
Post #1153334
dave-dj
Posted Wednesday, August 03, 2011 2:17 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014


Cool. Nice to see it's been useful and aided your daily routines.

What details are you recording on the physical processors?

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1153865
jamin_za
Posted Thursday, March 22, 2012 3:12 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 1:13 AM
Points: 2, Visits: 180
This was amazingly helpful - 5 starts!
Post #1270682
dbadude78
Posted Thursday, October 25, 2012 5:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 29, Visits: 439
Hi

I have followed this article step by step and get the following error.

Error at DiskUsage: The connection "ServerName=\\;Namespace=\root\cimv2;UseNtAuth=True;UserName=;" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Any ideas?

thanks
Post #1376919
dave-dj
Posted Thursday, October 25, 2012 5:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014
Hi,

looking at the error, it's not picking up the servername correctly, so check the source table column names and inparticular look at step 6 again..

Step 6 - Building The Server Query Loop
Now we have server to query, we can build the loop to iterate through the server list.

Add a For each Loop Container to the data flow work area and name it FELC Server Query. Double-Click the For Each Loop Container and select Collection. On the Collection form,

•set the ADO Object Source Variable to User::ServerList.
•Select the Enumeration mode to Rows in the first table
•Under Variable mappings, map the Variable User::ServerConnString to index 0.


make sure you are mapping the variable User::ServerConnString to an index value of 0

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1376934
dbadude78
Posted Thursday, October 25, 2012 6:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 29, Visits: 439
Hi

Thanks for the quick response.

The source table [server_query_list] has the server name without a forward slash e.g. [Servertest]. The ServerConnString is set to 0.

thanks


Post #1376948
dave-dj
Posted Thursday, October 25, 2012 8:23 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014
stick a breakpoint on the WMI task and check the variable value pre wmi query execution and check the value is ok

Also on the wmi_conn connection manage review the connection string expression.

let me know what you have in there

is short the problem is the value isn't being set in the connection string so it's pin pointing where the server name is getting lost

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1377015
dbadude78
Posted Friday, October 26, 2012 5:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 29, Visits: 439
Hi

I finally got there at the end, it was something in the WMI connection manager

thanks again
Post #1377483
dave-dj
Posted Friday, October 26, 2012 11:25 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014
No probs - glad you got it working

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1377757
« Prev Topic | Next Topic »

Add to briefcase
30 posts, Page 3 of 3
«««123

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.