I don't know if this it's possible but nowadays as almost everything is possible I am asking to see if anyone has any idea.

The problem is:

Regularly I have to import files (CSV, XML, Excel, ...) to an SQL Server Database and after I import the files I have to map the content of the columns of the imported files in a .sql Script to run and insert in a table in another DB (this table is the same for all the files imported).

I spend a lot of time on these mappings as you can imagine, I want to know if it's possible through Artificial Intelligence or Machine Learning one solution that can make the import of the initial data to the final DB, the initial import I can make it automatically the problem is only the import of the imported files to the final DB.

Note: The initial files don't have the same columns names, each file can have different columns names.

Sorry for the long post but I don't know if it is possible something like that. I searched and don't find anything.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.