Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

powershell and ssis Expand / Collapse
Posted Wednesday, March 20, 2013 4:40 AM


Group: General Forum Members
Last Login: Tuesday, September 29, 2015 9:32 AM
Points: 120, Visits: 467
hi all,

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

Post #1433123
Posted Thursday, March 21, 2013 8:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 5, 2016 7:18 AM
Points: 262, Visits: 691
Which part are you having problems with, gathering the data with PoSh or pushing it back in SQL?

Rick Krueger

Follow @dataogre
Post #1433817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse