How to copy data from CSV file that has one column with line breaks
My source CSV file has two columns that have huge chunks of texts with lots of line breaks. When I use Copy activity to read this file in ADF, it breaks the rows whenever it sees an line break instead of actually parsing the complete row. …
Removed trigger still triggers
Hi! I had a trigger in Azure Data Factory with a related pipeline. The trigger has been deleted (and the change published) but it is still triggering over 12 hours later. The trigger is not in the GUI, not connected to the pipeline and not in Git.…
Pipline Failure
Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Conversion failed when converting date and/or time from…
error with ssis package in azure Failed get parameter info of parameter sql password
There is an SSIS package running on a schedule in Azure. The SQL database is also in Azure. The SSIS package moves data from SQL to D365. I am getting this error when the package starts to run: error with ssis package in azure Failed get parameter…
About copying in ADF/Synapse sucessfuly
Hi I'm copying CSV file (on Prem) to a Parquet file on ADLS2. Just copying one single file. If the Copy activity ends sucessfuly (Succeded state in the activity) ... is that a garanty that the file was copied well?? Regards

Azure Devops error invalid parameters
Hi, Invalid parameters error in ADF azure devops armtemplate deployment what can be issue in armtemplate { "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#", "contentVersion":…
copy data gives error NullReferenceException: Object reference not set to an instance of an object
I'm copying from Azure Blob Storage .csv files into Snowflake, and receiving the error ErrorCode=SessionLogFailToWriteLog,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Write log is failed with error message:…
toDecimal function in dataflow of ADF/Azure Synapse Analytics not working correctly
I have input string field with name COST with below values. COST 2753000 217400 500 252567552 I am using toDecimal function in derived Column transformation in dataflow as below. z_COST= toDecimal(trim(COST)) Output is as…
Why does ADF copy activity to Oracle RDBMS configured with concurrent connections and degree of parallelism always fail?
Configuring ADF copy activity to read from Azure Blob Storage and concurrently write to Oracle database (to speed up the copy activity) fails always with ORA-00054 "Resource busy and acquire with no wait error.....". DBA says ADF had X active…
Sudden slowness on Azure Datafactory pipelines while fetching data from oracle database
Hello, We have been running ADF pipelines to ingest data from Oracle database. Suddenly it started taking 7-8 hours to finish whereas earlier it was 2-3 hours. No changes on Network end. Self hosted integration runtime was upgraded on 18th Jan-2025 where…
Azure Data Factory Copy Activity fails to auto create table when copying from REST source to Azure SQL database
I am using a Copy Activity in Azure Data Factory. I have a REST source/data set created and a Azure SQL Database sink/data set created. I have the Copy Activity set to auto create and the table does not exist in the database before running the pipeline…
Azure Data factory: Linked service parameterization default values and CI/CD pipelines
I am struggling to understand how ADF parameterization functions when deploying from one environment to another when using DevOps pipelines. Our linked services may be set up with parameters such as "name":…
Azure Data Factory Web activity calling child pipeline across ADF instance
I have child pipeline in ADF Instance 1 which invoke rest api POST method through web activity Parent pipeline is in ADF instance 2 which call above child pipeline also through web activity. I am able to successfully call child pipeline from parent…
delta file Vaccuum Immediately dataflow
Hi , I am using Azure data factory Data Flow source is parquet file sink is Delta file . I wanted run the vacuum immediately keeping no history . do we have any option for that please . Sink is Delta File in the Dataflow
Based on wildcard (part-*.csv) I want to pick multiple part files and insert into SQL Server
I have a blob path where spark is writing multiple part files . Now I want to load all these part file data to SQL Server . I'm trying using wildcard character *.csv in ADF but it's not working. I tried using listing the files via GetMetaData but still…
Error DF-EXPR-010 in ADF data flow, Column 'body' used in expression is unavailable or invalid
I need to take the results of a REST API query and transform them to upsert them into a table. The source returns this JSON: The Projection step ALWAYS puts the content in context of a body field. I can't figure out how to feed in the expected schema…
XML to JSON conversion in ADF missing out 'lang' tag details
I am converting an xml from html source to a json file using ADF. However, for one of the attributes, the 'lang' element is not getting translated. The xml data in file is as follows: ''' <displayname xml:lang="deAT">…
Running MongoDB Aggregation Operation in Azure Data Factory.
Hi, I want to query my MongoDB Atlas (Not Cosmos DB) to fetch data and process it in Azure Data Factory. I have successfully created a connection to MongoDB and can run filter operations. I want to perform aggregation operations like $lookup with the…
NAT Gateway for Managed VNet IR
How can I make Azure Managed VNet IR to make requests through a static public I.P? I want to pull data from 'xyz.com/books' api. This API provider doesn't allow requests from everyone. They only allow requests from IPs which are whitelisted. I have…

ADF Copy Activity for JSON filesfails to Locate Blob Despite Successful Metadata Retrieval
I’m currently working on an Azure Data Factory (ADF) pipeline that consolidates files from multiple source containers into a single target container. The goal is to gather one file type (lod2) from various resource-based subfolders and versioned folders…