Jeff Moden (7/18/2014)

---

Koen Verbeeck (7/18/2014)

---

Ed Wagner (7/18/2014)

---

Koen Verbeeck (7/18/2014)

---

Jeff Moden (7/18/2014)

---

@Koen,

Now you see why I never get into SSIS. I just don't need it.

Everyone has his own tool. I can say the same thing about BCP 😀

You know, Koen, this it the type of thing that almost makes me want to learn SSIS.

I'd probably start with something simpler, but that's for another day. I haven't found anything that was impossible with SQL yet, but I'm sure that day will come eventually. 😉

Importing multiple files in parallel 😉

That's not impossible using T-SQL. Just different. I've built many an ETL that does just exactly that without SSIS. I will, however admit that SSIS allows for more easily (click and drag the right block connector type) "waiting" for a given set of parallel imports to complete before continuing the process but even that's not all that difficult to pull off in T-SQL. It's just different.