Hello Noveen Haseeb,
Greetings! Welcome to Microsoft Q&A Platform.
I understand that when you upload the csv files to Blob storage via SSIS ML jobs which loads data from on-prem database tables to Azure Blob container you are getting the error message "Unexpected error occurred when transferring data into blob: Unable to create Azure Blob container. Endpoint" Below are some considerations to check and resolve the issue,
Ensure that your SSIS environment is configured to use correct TLS version and you have added the registry keys to enable TLS version accordingly and restart your SSIS service after making these changes. Refer - https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#use-tls-12
Make sure you have the necessary permissions to upload content to the BLOB. Check the access control settings for your BLOB storage account.
Verify the firewall settings on the storage account are blocking access to the container. You can check the firewall settings on the storage account and ensure that your IP address is whitelisted.
Check if the SAS token you are using to authenticate has expired. You can generate a new SAS token and update the connection manager in SSIS to use the new token.
refer - https://learn.microsoft.com/en-us/azure/architecture/data-science-process/move-data-to-azure-blob-using-ssis for configurations.
Similar thread for reference - https://stackoverflow.com/questions/65713694/cant-upload-files-to-azure-storage-using-ssis, https://stackoverflow.com/questions/10905044/ssis-transfer-database-task-cryptic-error-message-0x80131500
Hope this answer helps! Please let us know if you have any further queries. I’m happy to assist you further.
Please "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.