SQL Server 2005 Flat File Import
Posted on 2006-07-10
I know this should be really simple but I am stumped. I am trying to import a text file into a SQL table and I'm having problems.
The original flat file is 38 columns of which I only need to import about 25. On the advanced tab of the wizard, I delete out the columns I don't need and then finish the rest of the steps. All of the column widths are set to NVARCHAR 50 except for six columns that I need to set to NVARCHAR 500. The problem is that every time I try to finish the import it bombs out on those columns with truncation errors. When I preview the text file after the deleted columns, it also looks like it kept the data but just shifted the column headers over.