If that is what you must do, then the TEXT datatype is certainly one way to go.

To see if the Standard Edition will create a table with multiple text columns,...

Sure, Karthik... let's answer question #2 first...

'dtProperties' is a special table used by things like the "Visual Database Design Tools".  It even has to be modified if you want to...

Perfect... thanks, Bill.

Josef,

Need a couple of things from you...

1. Would you post the first 10 lines from any of the files?
2. Would you post the table creation statement for the StockData table?
3. If possible, would...

Since I don't use DTS or SSIS for this type of stuff... what happens to the data that caused the error?  Can the error handler be made to save the...

Heh... thanks Lowell

Aye... nicely done, Lowell... and, I think you'll really like this, as well

Just in case someone can't use xp_CmdShell, there's a little known...

That's kinda why I use BCP for this type of stuff... you can program BCP to survive just about any error and squirrel the "bad" rows in a separate file...

Hust for a point of reference... we set TempDB to be 9 gig on bootup.

You are correct... things are going to get a little complex because you need a query to build a dynamic query from Master.dbo.SysServers.

For more reasons than I can count, you will likely regret the day that you used Text or NText if there's any chance of ever needing to edit the column.

Creating...

Did you TRY it?

Ganapathi,

It's good that the code works... but do you know WHY it works?

The only thing I can see that might be doing this is your 11PM DB Maintenance job... check it and see if you are "regorganizing" the data... there's at least...

You bet... thanks for the feedback...