not tried it yet, but reading through it seems very interesting and useful.:-D

I'd be interested to know about the SSAS article when its done.,

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

Does it tell you what conponent is failing?

You need to create a select query for what ever hardware / software values you want. like

SELECT FreeSpace, DeviceId, Size, SystemName, Description...

noyt sure I completely understand what your trying to do, but I'll take an estimated guess at two possibilities:

1 - you want to call the functions from the database within...

Guys and girls, this seems like an appropriate thread to tag onto.

My db and relevant SSIS processes have been developed on a local copy of SQL server collation Latin1_General_CI_AS. ...

cool. I won't need to change much at all then 😀

sorry, but if your using don't save sensitive where is that info being supplied from when it's run from an SQL agen job? - configuration tables?

how would the don't save sensitive work in that scenario - I assume it would mean defining the connection security details in the job or command line then?

Also, if I...

Hi Lowell,

Yes I did thank you. I appreciate the help.

duplicate post removed

Keon,

Thanks again for another answer, it's exactly what I was looking...

Dan.Humphries (3/23/2011)

---

I may be missing something but I would create a temporary staging table that I could throw the record set into and then using it as a source table...

opc.three (3/14/2011)

---

You can achieve this by using the Derived Column Component to add a blank column to your data set and then using a "Transformation Script Component" to populate...

thanks for the reference

ok thanks, I'll look into that.

Seems stupid that MS introduced the SSIS expression language instead of using T-SQL or vb or c#. I guess they had there reasons, but...