We've written an automate to do a pretty simple "Loop through the contents of file", put the contents into a variable and then write to a different file contents using Mid() and a custom date function. We're looping a 9mb file but it takes 4.5 HOURS for this thing to run. Attached is a screen shot of most of the task. I am wondering if there would be a more efficient way to perform this? The reason for the Mid() is that the input file is fixed length fields that I want to write to a "not symbol" delimited file. The special function converts a 7 digit date to an SQL Friendly one. We then bulk load a database table with the new file.
