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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-18 : 08:50:22
|
| shane writes "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 use Active X on this column for data cleansing. ie removing erroneous characters %O, %OA etc.The data from the column is 300 chars approx. The error message when we test this is "Data for source column is to large for specified buffer size"Data is being transferred but after 256 chars forget about it.The destination column is 500 varchars.The Active X script used on the transformation isFunction Main() strTransfer = 0 strTransfer = DTSSource("Col041").value if NOT ISNULL(strTransfer) then strTransfer = Replace (strTransfer, "%3A" , ":" , 1) strTransfer = Replace (strTransfer, "%2C" , "," , 1) strTransfer = Replace (strTransfer, "%0A" , " " , 1) strTransfer = Replace (strTransfer, "%25" , "% " , 1) strTransfer = Replace (strTransfer, "%28" , "(" , 1) strTransfer = Replace (strTransfer, "%29" , ")" , 1) end if DTSDestination("commentdata") = strTransfer Main = DTSTransformStat_OKEnd FunctionIve been told that %3A is hexadecimal charater for a line feedThis maybe the problem...Has anyone encountered this problem and any work aroundswould be appreciated." |
|
|
|
|
|
|
|
DTS Data Pump truncating after 256 chars