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.
I am very much interested in learning how to import using both tools. With SSIS I am bit slow as I am still learning how to script using the .net language .@Koen and Jeff really appreciate your assistance.