Question

SBH001 on Mon, 11 Jun 2018 08:07:00


Hi ,
My actual requirement is  dump data from MsAccess Source to the Azure SQL Database.
I have create pipeline named "GetExistingIDs" and another pipeline as "Migrate Data from Ms Access to Azure SQL".
In the Third Pipeline "Pipleline1" connected these two Pipelines. "GetExistingIDs" Execute Pipeline Activity output will be input paramter of the execute pipeline "Migrate Data from Ms Access to Azure SQL". 
 The output will of the "GetExistingIDs" Pipleline is as shown below:

 {
    "firstRow": {
        "PIDs": "'XXX1291','XXX1293','XXX1321','XXX1325','XXX1330','XXX1340','XXX1355','XXX1358','XXX1361'"
}
}

Relation Source Query in  "Migrate Data from Ms Access to Azure SQL" Pipleline:
SELECT t.* FROM [tblCPP070: P Info (Raw)] t where PID  not in (@{pipeline().parameters.t.PIDs})

Input Paramter "t" Expression  : @json(activity('Execute Pipeline1').output).firstRow

Error:

{ "errorCode": "BadRequest", "message": "The expression 'json(activity('Execute Pipeline1').output).firstRow' cannot be evaluated because property 'firstRow' doesn't exist, available properties are 'pipelineRunId, pipelineName'.", "failureType": "UserError", "target": "Migrate From MS Access To Azure" }

Query :

1.Expression not evaluted in the input paramter as well as in the SQL query .
2.When Access the Ms Access Via Relational Source why tables are not listed automatically as dropp down as we have the table drop down list in the oracle a and other source connections. Forcing to write the Query to access  the table details like this "SELECT t.* FROM [tblCPP070: P Info (Raw)]". Why so?

 How to proceed further?


Sponsored



Replies

Wang Zhang on Mon, 11 Jun 2018 09:46:01


Hi, for #1, please try '@{activity('Execute Pipeline1').output.firstRow}' as the expression for Paramter "t", thanks.

SBH001 on Tue, 12 Jun 2018 14:23:05


Hi,

Tried the above mentioned solution, but it is not working. 

Note: "t" expression is object type.

Getting Error as :

{ "errorCode": "BadRequest", "message": "The expression 'activity('Execute Pipeline1').output.firstRow' cannot be evaluated because property 'firstRow' cannot be selected. Property selection is not supported on values of type 'String'.", "failureType": "UserError", "target": "Migrate From MS Access To Azure" }

Actually expression is not evaluating in the parameter.

Any other solution plz..?