powershell and ssis

• n00bDBA

  SSCrazy

  Points: 2986

  More actions

  March 20, 2013 at 4:40 am

  #291010

  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

• Rick Krueger

  SSC Eights!

  Points: 856

  More actions

  March 21, 2013 at 8:34 am

  #1599407

  Which part are you having problems with, gathering the data with PoSh or pushing it back in SQL?

  ---

  
  Rick Krueger

  Follow @dataogre