I am trying to load a Blob CSV into SSIS in a Flat File destination.
You can see in my source editor that columns are appearing (So its reading my CSV blob file)
When I run SSIS, it returns me these errors:
[Azure Blob Source] Error: The remote server returned an error: (400) Bad Request.
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
What I am doing wrong here?