This is beautiful! Exactly what I wanted and so much to follow up on and learn. Thank you *very* much for the info and example. I implemented per your example...

Separate rows is fine. I'm not trying to make this overly complicated. Perhaps I'm asking a silly question, and I apologize if so. Below is what I'm talking about. I'm...

OK. I understand the function aspect, but back to my original question, within said function, do I just have a bunch of simple, separate statements, each with their own WHERE...

Thank you! This is good info. Love having more options.

Can you elaborate briefly on how exactly that should be done? In SSMS, when logged in to Integration Services, my package is already in MSDB. I can drop and re-create...

Understood, and agreed. I very much appreciate your input, though. Going to study your method and learn from it -- very interesting.

No. In my scenario, Luis' routine correctly generates 5000 records; yours generates one. In my text file, each "record" spans 35 lines. There are 35 lines x 5000 records =...

Dwain.c, your code generates a single output row, not one for each record (comprising 35 rows) in the source file.

Thanks for the clarification guys, helps a lot. I can, indeed, access the files from the SQL Server so a bulk insert should work well. I will implement via a...

Wow, I very much appreciate this input. I follow what both of you are saying and never would have thought of either. I will attempt to implement both and see...

An "ODBC-Call Failed" error can be due to many things. The error message is usually accompanied by some further info which is more helpful, such as "Primary key violation." If...