none
Azure Data factory V2 pipeline parameter passing RRS feed

  • Question

  • hi guys , 

    im trying to pass a parameter from pipeline to a copy activity . where im using the parameter in a sql query . but i keep on getting error when i trigger the pipeline . Can you please help where im doing it wrong

    this is the sql qeury im using in the source copy 


    SELECT A.ACCOUNT_NO, A.DATE_BILLED, A.DATE_PAYMENT_DUE, A.TOTAL_BILL_AMT, A.LPC_AMT, A.BILL_CYCLE_DATE, A.BILL_FREQ, B.TOTAL_AR_BALANCE, A.BILL_CYCLE_TYPE,A.PREV_AR_BALANCE 
    FROM WECDWTS1.CSS_BILL_TRAN A LEFT JOIN WECDWTS1.CSS_Account B ON A.ACCOUNT_NO = B.ACCOUNT_NO
    WHERE A.BILL_CYCLE_DATE =@pipeline().parameters.billCycleDate
    AND A.PROCESS_STATUS IN (6,7)

     

    Wednesday, September 11, 2019 7:27 PM

All replies

  • Hi tarunnyc,

    Could you try the below query and let us know how it goes. : update your dynamic expression to 

    @{pipeline().parameters.billCycleDate}


    Use query as below:

    SELECT A.ACCOUNT_NO, 
    		A.DATE_BILLED, 
    		A.DATE_PAYMENT_DUE, 
    		A.TOTAL_BILL_AMT, 
    		A.LPC_AMT, 
    		A.BILL_CYCLE_DATE, 
    		A.BILL_FREQ, 
    		B.TOTAL_AR_BALANCE, 
    		A.BILL_CYCLE_TYPE,
    		A.PREV_AR_BALANCE 
    FROM WECDWTS1.CSS_BILL_TRAN A 
    LEFT JOIN WECDWTS1.CSS_Account B ON A.ACCOUNT_NO = B.ACCOUNT_NO
    WHERE A.BILL_CYCLE_DATE =@{pipeline().parameters.billCycleDate}
    AND A.PROCESS_STATUS IN (6,7)

    If you still see errors, please share complete error details/message.


    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered"Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.



    Thursday, September 12, 2019 1:35 AM
    Moderator
  • Hi tarunnyc,

    Just checking in to see if the above suggestion was helpful to resolve your issue. If this answers your query, please consider to click “Mark as Answer” and Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.


    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Friday, September 13, 2019 2:05 AM
    Moderator