My source data is a flat file, semicolon-delimited, and has three columns.ÃÂ The first is 10 chars, the second can be up to 240, and the third can be up to 240.ÃÂ For the import I select "Flat File Source" for the Data Source.ÃÂ When I select my source file, I use the Flat File Manager, Advanced tab, to configure it as follows:
I leave the defaults for Column 0.
For Column 1 I select a DataType of Unicode String and set the OutputColumnWidth to 240.
For Column 2 I select a DataType of Unicode String and set the OutputColumnWidth to 240.
On the Destination page I choose "SQL Native Client", and point it at my database.ÃÂ The destination table has 3 columns.ÃÂ Column 0 is CHAR(1), Column 1 is NVARCHAR(240), and Column 2 is NVARCHAR(240).
However, when I get to the "Select Source Tables and Views" page of the wizard and hit the "Edit" key under "Mapping", it shows a size for all three columns of "50".ÃÂ Sure enough, when I perform the import, it truncates everything to 50 characters.
How do I get more than 50 characters to import?
View Complete Post