Post reply

Setting variable in Pipeline

  • November 25, 2020 at 4:43 pm

    #3813921

    Hi all,

    I’m wondering if someone can help us out here as we are going round in circles.

    In short we are trying to;

    1.       Read a value from a SQL table via a stored procedure in a lookup task.

    2.       We want to use that value to set a variable so we can use it in a copy data task.

    However our set variable task using (@activity('Lookup1').output) returns the value but its wrapped in lots of JSON (see attached)

    In the attached we are only interested in the TokenGUID value, not the rest of the JSON.

    So can someone point us in the direction of how we would set a variable to be a string value.

    Thanks,

    Nic

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

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • November 26, 2020 at 5:10 pm

    #3814249

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • December 21, 2020 at 11:03 pm

    #3823023

    You can just use the property by following the path:

    @activity('Lookup1').output.firstRow.TokenGUID

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

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