CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-factory
AlvinfromDiaspar
AlvinfromDiaspar

Reputation: 6834

Azure Data Factory SQL Sink parameter str1?

What is "Str1" ? Is this a general string type instead of varchar or nvarhcar?

Example:

"sink":
{
    "type": "SqlSink",
    "SqlWriterTableType": "MarketingType",
    "SqlWriterStoredProcedureName": "spOverwriteMarketing", 
    "storedProcedureParameters":
            {
                "stringData": 
                {
                    "value": "str1"     
                }
            }
}

Reference

* Updated *

My problem is now resolved. These parameters are the parameter values. For dynamic parameters you need not specify them here in the JSON.

Upvotes: 0

Views: 385

Answers (1)

Sharon Lo
Sharon Lo

Reputation: 39

"Str1" is just a general string type. You can see the schema for a data pipeline defined here: https://datafactories.schema.management.azure.com/schemas/2015-09-01/Microsoft.DataFactory.Pipeline.json (You would want to look at sqlSink specifically)

Upvotes: 3

Related Questions