Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-8609

SQLServer : SQL Query Task

    XMLWordPrintable

Details

    • Hide

      Unit testing via pester? 

      Acceptance testing

      No docs update needed.

      Show
      Unit testing via pester?  Acceptance testing No docs update needed.
    • Windows
    • 1
    • Windows Hopper
    • Needs Assessment

    Description

      Many of the tasks and plans that need to accomplish tasks will need to know how to do sql queries.

      This ticket will create a sql query task so that plans will have the ability to execute t-sql code on a server.

      The result of this task should always be a json object representing the resultset of the query.

      The raw task should not be exposed to users of the PE console, as we don't want console users to be able to execute arbitrary t-sql via the console. This task should only ever be consumed by plans so that the basic query, if not all of it's parameters, can known via a code review process prior to implementing.

      Need to decide on a strategy to accomplish this. May have to write a new PowerShell cmdlet that will do a query and return json.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              william.hurt William Hurt
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support