What’s the recommended go to application for importing data these days?
We have. Product information management (PIM) system that I’m creating DMT files from using SSIS. I then manually run them through DMT. I want to automate that some how. There will be multiple like files with a time stamp e.g part_1113211700.csv. We had service connect in the past but that did stress my brain.
Don’t mind a little subscription service but not looking to invest in a platform. Just automate DMT style processes