Tools for importing

[richard_cj_gardner (Richard Gardner)]

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

[gpayne (Greg Payne)]

@richard_cj_gardner Search the site for DMT and Powershell. You will find several threads like this one.

DMT Powershell Help

I ended up doing it like this: $ImportName = ‘“Part Warehouse”’ Start-Process -Wait -FilePath $DMTPath -ArgumentList “-SSO -Add -Import $ImportName -Source $Source1”

[richard_cj_gardner (Richard Gardner)]

Thanks Greg. Have been able to accomplish what I needed using Powershell. I knew it was possible but am not totally familiar with PS and thought it would be hard to loop through unknown file names. Seems like it wasn’t hard at all!