Post reply

Power Query SSIS

  • January 6, 2022 at 5:18 am

    #3970404

    post deleted.  i figured it out.

    • This topic was modified 2 years, 10 months ago by  water490.
    • This topic was modified 2 years, 10 months ago by  water490.

    Attachments:
    You must be logged in to view attached files.

  • January 6, 2022 at 3:14 pm

    #3970586

    What was the solution? I'd be interested to know, because I haven't used PowerQuery inside SSIS yet.

    (Do you still have to write the PowerQuery in Excel or PowerBI and then copy and paste it into SSIS?)

  • January 7, 2022 at 3:56 am

    #3970761

    No problem

    I created the Power Query in Excel and then copied it to the Power Query task in SSIS.   I used the link you provided for the steps in a separate thread. That is as far as I got.  I still have to figure out the rest of the data flow.  This is my first time using SSIS so I am spending quite a bit of time on YouTube watching videos on it.  SSIS looks really promising.

  • January 7, 2022 at 7:09 pm

    #3971005

    Thanks for the update. It's pretty much what I expected to have to do... use something (PowerBI, Excel) to generate the PowerQuery and then copy and paste.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply