@@AllAboutBI Thanks for this awesome video. I wanted to ask what I need to change if I want the file name to be the same name as the source file name plus the date.
What if our sink destination is an SQL table?? How can we create a dynamic table name using the original file name of the data source (for an excel data source)
Hi Maam, I have followed the exact same steps in your video to set variable to dataflow to set sink dataset filename . But I am getting this error and pipeline execution is not starting Error: { "code": "BadRequest", "message": null, "target": "pipeline//runid/1f3e4fad-5ec4-4666-8070-a310f0702153", "details": null, "error": null }
@@AllAboutBI I removed the dataset parameter for file and pipeline is executing but I am getting another error in dataflow level. Before parameter passing dataflow ran successfuly. Job failed due to reason: com.microsoft.dataflow.Issues: DF-ARG-007 - store is not defined - [564 737],EXE-0001,Dataflow cannot be analyzed as a graph
Super useful for beginners.... This video made it clear on how to set the target file names
Very much useful for the beginners like me
very useful please keep it coming with few complex examples. would really help a lot. Thanks in advance
Sure thing!
Great video mam 👍
Thanks very useful
Nanri for your all your hard work. Keep it going . Helped me a lot !
Comments like this keep pushing me. Thanks a lot!!
@@AllAboutBI Thanks for this awesome video. I wanted to ask what I need to change if I want the file name to be the same name as the source file name plus the date.
What if our sink destination is an SQL table?? How can we create a dynamic table name using the original file name of the data source (for an excel data source)
How can I export schema of tables from SQL Server database to sink in csv file format and store in azure blob storage using ADF synapse?
Hii mam can u explain optimization techies in adf
Hi Maam, I have followed the exact same steps in your video to set variable to dataflow to set sink dataset filename . But I am getting this error and pipeline execution is not starting Error: {
"code": "BadRequest",
"message": null,
"target": "pipeline//runid/1f3e4fad-5ec4-4666-8070-a310f0702153",
"details": null,
"error": null
}
Post your screenshot with setting
@@AllAboutBI I removed the dataset parameter for file and pipeline is executing but I am getting another error in dataflow level. Before parameter passing dataflow ran successfuly. Job failed due to reason: com.microsoft.dataflow.Issues: DF-ARG-007 - store is not defined - [564 737],EXE-0001,Dataflow cannot be analyzed as a graph