CSV file to SQL Server import
I am creating my first flow where I am trying to import from csv to SQL server on azure.
I made all the connections but when I select Insert as the SQL query its asked to write an insert query. Can I just not map the field in csv to columns in SQL server? Do I need to write a query?
0
Comments
Thank you for reaching out!
At the moment, we don't have a feature that allows you to map fields in a CSV file directly to columns in SQL Server without having to write an insert query. However, I do have some good news for you!
Our team is currently working on implementing this feature, and we expect to release it in the next few weeks. This feature will auto-map fields from your CSV file directly to columns in the SQL Server table without manual intervention. We will update the release notes and this community post once it is available.
Please let us know if you have any further questions or concerns. Thank you for your patience.
Thanks,
Rohit
Please sign in to leave a comment.