ActiveX script fails with buffer overrun error.

[mkal]

I am trying to import a .csv, Excel 2000 (10.4524.4219)Sp-2 is used as the data source, into a sql table. This transformation task fails with the Error msg. &quot;Data for Source Column <number>('Column_name') is too large for the specified buffer size.&quot;

I've located the KB article 281517 for this error(

http://support.microsoft.com/default.aspx?scid=kb;en-us;281517&Product=sql2k)

and followed the instructions (registry hack)for both the source server, destination server and computer the dts package is running on but it still fails. I've also, tried creating a dummy row and insert it into the .csv file making sure it was in the first 8 rows as suggested by anothter post but this too has failed to correct the problem. In addition I located the offending row and moved it so it was in the first 8 rows only to get the same error msg only this time for a different column. Chances of finding one row to satisfy every field in the feed is an exercise in futility.

Anyone have an idea as to why, why it keeps failing? This has been an eternal thorn in my side and I would like very much to resolve it.

 

[mkal]

Thought I would pass on this info as it may save someone else some headaches.

It was only by chance that I managed to solve my own problem.

The Transform Data Task actually works. My first post (after re-reading it, it lacked info) was in reference to the test for the ActiveXscript Transformation properties - that still fails. I had never thought to actually run the Task after the test failed but by accident I kicked it off one day and it executed without an error and without corrupting the data. Why the ActiveXScript export to a text file fails but the actual Transform Data Task succeeds is a mystery but I'm not complaining.