Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works)

My feedback

  1. 6 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  General  ·  Admin →
      Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works) commented  · 

      Updated by PW to include some additional filter options that might be valuable.

    • 1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  General  ·  Admin →
        Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works) commented  · 

        You can connect to an Amazon RDS SQL Server instance using standard SQL connections, thus the current components that we offer with SQL Server support should be working. If you are experiencing an issue with those, can you provide some more detail? Or is there some other functionality you are looking for?

      • 2 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          under review  ·  1 comment  ·  General  ·  Admin →
          Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works) commented  · 

          Unfortunately, due to the way the SSIS data flow engine works, we can't work with live data in the Advanced Derived Column at design time. This would require that we execute the source components and all transforms preceding the Advanced Derived Column, and SSIS does not support that at design time.

          You can test it with real data by using a Data Viewer inline in your data flow, and setting a limit on your source query.

          If I've misunderstood the request, can you elaborate on it?

        • 1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  General  ·  Admin →
            Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works) commented  · 

            Could you elaborate on what connection managers you would like to see supported?

            Also, please describe your scenario for dynamic database or table definitions in a little more detail. An example would help us better evaluate this request.

          • 5 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  General  ·  Admin →
              Pragmatic WorksAdminPragmatic Works (Admin, Pragmatic Works) commented  · 

              Thanks Marvin for using UserVoice. We will explore how to implement this component in ssis.

            Feedback and Knowledge Base