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 |
|
shaneschmidt
Starting Member
17 Posts |
 Posted - 2004-05-12 : 00:35:40
|
| Help We have a DTS data pump from a text file to a tablethat is truncating data from a source column from 256 chars onwards.We also use Active X on this column for data cleansing. The data is 300 chars approx. The error message when we test this is "Data for source column is to large for specified buffer size"Has anyone encountered this problem and any work aroundswould ber appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-12 : 12:56:29
|
| So did you create the table first or did you let DTS create the table for you? I would suggest creating the table outside of DTS so that it is defined how you want it as DTS will make assumptions.Tara |
 |
|
|
|
|
|
DTS Import truncating Data > 255 characters