sqldriver (2/17/2014)
I think doing that bit of pre-processing with PS should be fine; it's just one line, even if it is ~75 times.
It would be interesting to see which approach was faster. Preprocess the files to a single file per report type or import each file separately into a common table.
Is the pre-processing route the way you're going to go on this?
--Jeff Moden
Change is inevitable... Change for the better is not.