im trying to build a data collection of various sql servers. currently i do most of the data gathering just running a dmv query in ssis and loading the data into my collection db.
Id like to be able to use powershell to run some queries and add that data to the collection db as well. but struggling at the moment..
I can get powershell to run in ssis (made a simple create folder script and ran it in ssis) but i cant work out how to gather data with posh then push it out to a db..
thanks for any help