1
$\begingroup$

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.

$\endgroup$

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.