I came across a problem in Microsoft's Enterprise Manager import functionality.

I have a table with a field (GOInfo) which is varchar(1024). Pretty straightforward, right? Well, if I right-click on the table, and select "Import data", planning to insert some rows from, say, a tab-delimited text file, which has the corresponding GOInfo column, I would have expected the resulting inserted rows to have up to 1024 chars in the GOInfo field. Not so - it seems that the import "wizard" limits source (incoming) varchar data to 255 bytes.

I could not find any way of changing this, and I couldn't find anything in the Help documentation.
So... two questions:

1) Does anyone know an easy solution in DTS/Enterprise Manager?
2) Does anyone know if bulk_insert has this limitation/capability?

Thanks in advance,