[dba-SQLServer] table definition file

jwcolby jwcolby at colbyconsulting.com
Fri Mar 23 11:36:20 CDT 2012


Guys,

I got a database today which I suspect is a flat file, fixed width, pad right.

I got a "table definition file" with hundreds of lines like:

365,Physical_Address_Results,varchar(50)

Which is basically column number, field name, data type.

Is there anything built in to SQL Server to take such a table definition file and create the table 
from it?

Once created, something to pull the fixed width file into such table?

The file itself is 270 GIGABYTES with a .txt extension.  I am having a problem even seeing the 
contents.  I imagine I can open it in SQL Server directly in the import wizard but I really don't 
want to have to manually go set up the fixed width import stuff from inside of that wizard.

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it



More information about the dba-SQLServer mailing list