Thanks very much for a great article. Some of the methods I knew, but others were an education for me. Appreciate your time and efforts!

Sergiy,

I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.

In the future, maybe you ought to question what you...

Well said, and understood - all good point. And yes, the solution I found actually came from a number of members, yourself included.

Thanks for that!

Point taken, and most of the time, good advice. Thanks for offering it!

Jeff - Look at the fourth and sixth small paragraph of my original post. I did exactly what you are suggesting I did not do. I asked to...

Alex,

Here is the basic code I used. This produces a nice temp table of information and of course, you can edit the query if you don't want all the...

Hanshi,

Thanks for your reply, but unfortunately its way over-complex. I found a way to do this that is simple and elegant.

1. Run SP_COLUMNS and direct output to a Temp...

Luis,

No - it was not a problem - I saw what you were doing but it wasn't quite what I was after (my fault, not yours).

I Brandie,

Let me try to provide you some answers...

We use SSIS when its truly needed, but sometimes we actually use old DTS, or even just an ASCII dump directly into...

My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very simple...

My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get tables"...

Thanks Drew... That worked swimmingly!!!