Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slb
Starting Member
4 Posts |
 Posted - 2008-09-03 : 11:06:05
|
| I am importing from a flat file with column and row delimiters - there are just over 200 columns and over 7000+ records in this flat file. One of the columns is a notes field (column 189) which is to big for sql (I'm assuming because I originally started getting truncating errors and a count of the text of the field returned over 71000 characters)Anyway what I have tried to do is on the Source Column Mappings I have selected <ignore> under the destination column - I double check the destination mappings and the sql create table script and the column is not there - I finish and run but it still blows out referencing column 189I check the preview after I select ignore in both the source mappings and destination mappings and I can still see column 189.Any help would greatly be appreciated... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 03:07:50
|
| it seems like you've not refreshed after you removed the long column. after every change in column metadata you need to click on transformation and it will ask for deleting invalid references and you should do it. then only your metadata gets refreshed. else it will still hold column info in metadata. |
 |
|
|
|
|
|
column ignore not ignoring causing failure