I have created a flow which calls a MicrosoftSQL procedure which executes a SSIS Package. THe SSIS package has a step which exports data in a CSV file on the network. The flow runs successfully but the SSIS package execution results in error:
Export data to CSV file: Error: CSV File Destination failed the pre-execute phase and returned error code 0xC020200E.
Export data to CSV file:Error: Cannot open the datafile "\....csv".I have to mention that the user which I have created the connection with has access to the folder where the file is generated.
I have attached a print screen of the MS Flow configuration. The SSIS package transfers data between two databases and the final step is to export data from a MS table into a CSV file. In MS Flow I have created a connection to the database where the stored procedure is and that user has access to the location where the CSV file is generated. The issue is when I run the stored procedure from MS Flow..if I run it from MS Sql there is no error message.