Limitations of Product/Transfromations





Current limitations

  • Only OLEDB/Flat File Connection Managers and OLEDB/Flat File Sources are currently supported.
  • Only Azure Blob Storage linked services configured with Account key/SAS URI/Service Principal authentication are currently supported.
  • Only Self-Hosted IR provisioned under the same ADF where your Azure-SSIS IR is provisioned is currently supported.

Surrogate Key transformation requires all the column names to be unique

Comments

Post a Comment

Popular posts from this blog

How to access output of any activity in another connected activity. - Lookup Activity

Accessing Pipeline Variable Array elements in another activity by. @ variable ('NameOfPipelineVariable')[0]   -- 1st element @ variable('NameOfPipelineVariable')[1]   -- 2nd element @concat( variable ('NameOfPipelineVariable')[0], variable ('NameOfPipelineVariable')[1]) @{activity('Copy1').output.dataWritten} Accesses a property of the previous copy activity and passes the value of dataWritten. or  @activity('LookupTableList').output.value --- this will return full dataset i.e. all records returned by SQL in an activity. ------- @{activity('CopyBlobtoBlob').error.message -  For the failure case, pass the error output instead of  ----------------------------------------------------------------------- First Activity outputs a column named NewWatermarkvalue. select MAX(LastModifytime) as NewWatermarkvalue from data_source_table Below is how you access the output of the above activity in another activity in...
Read more