SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
Problem reading delimited text format file in Azure blob container from SQL server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 48%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lokesh
0
Reputation points
Hi,
I have connected a view from SQL server and trying to read the data from Azure container file for Power BI reporting purpose.I have used delimited text format for the sink(dataset).When I trigger the data below text is appearing in the sink file between the actual data.
**Recieved a soap fault while invoking end point target.This indicates a processing exception on the service end point side.please check service side loga to further diagnose the problem.
Can some one help me on the above error please.I am new to Azure data factory.
Thanks in advance!
{count} votes
-
Vinodh247 32,191 Reputation points MVP2023-08-03T16:18:13.4266667+00:00 @Lokesh: Do you see this error in the sink output files? that too inbetween the actual output data?
https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-delimited-text
-
Lokesh 0 Reputation points
2023-08-03T16:24:42.3+00:00 @Vinodh247 Yes.
-
Vinodh247 32,191 Reputation points MVP
2023-08-05T10:28:35.06+00:00 if you try to call that stored procedure in a seperate lookup activity are you getting the same error? or is it succesful?
-
ShaikMaheer-MSFT 38,521 Reputation points Microsoft Employee2023-08-07T07:49:58.4766667+00:00 Hi Lokesh,
Could you please help with below to understand your implementation and exact error spot better?
Are you seeing this error in Azure data factory? If yes, which activity? And exactly which point it is? Kindly share your activity configuration details.
-
ShaikMaheer-MSFT 38,521 Reputation points Microsoft Employee
2023-08-08T08:02:26.67+00:00 Hi Lokesh, Just checking if you get chance to share updates? Thank you.
Sign in to comment
Sign in to answer