SQL Column width from delimited text description |
|
|
SQL Column width from delimited text script was written to find the maximum length of each column in a delimited text file. When loading text files into database tables (MSSQL in this example), the source columns often do not match the table definition. This script was written to find the maximum length of each column in a delimited text file, then modify the a table create DDL file to make each character column wide enough, so truncation errors do not occur.
|
|