November 9, 2006 at 1:07 pm
Hi,
I am using WMI reader task to query event log from different servers. I just want to know that SSIS is using WQL or extended WQL. As WQL does not allow for count & datediff function but extended WQL does allow that. I need to use the count function as my package fail where there is no log entry for a specified date for server/log with the following error
Operation is not valid due to the current state of the object
.
So if I can use count then I will check it first to see if entries exists then I will run the query.
Please Guide.
November 9, 2006 at 6:28 pm
I think it does. Does this link help answer your question? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp
November 10, 2006 at 7:15 am
HI,
I know SSIS use the WQL but WQL does not provide count(*) function. Only extended WQL provides this. If I write this query in WMI Reader Task
Select count(*) FROM Win32_NTLogEvent
It will say invalid query.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply