Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

powershell and ssis Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 4:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:29 AM
Points: 119, Visits: 451
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, July 15, 2014 5:24 PM
Points: 262, Visits: 681
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