DTS Buffer Problems

• Green Armchair

  Hall of Fame

  Points: 3561

  More actions

  February 24, 2003 at 7:12 am

  #175317

  Hi

  We're running a DTS package that is pumping data from a table to a text file. The column that is being unloaded is type text.

  We're encountering the error:

  Step Error Description:Data for source column 1 ('XMLStream') is too large for the specified buffer size.

  I've found info on microsoft web site regarding a registry change to force DTS into sampling more rows before choosing the buffer size, but this all refers to Excel, not text files.

  Has anybody got any suggestions?

  Thanks in advance

• February 27, 2003 at 8:00 am

  This was removed by the editor as SPAM

• philcart

  SSC-Forever

  Points: 47794

  More actions

  February 27, 2003 at 4:14 pm

  #449987

  Check the following article

  http://support.microsoft.com/default.aspx?scid=kb;en-us;285006

  Thanks

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• Green Armchair

  Hall of Fame

  Points: 3561

  More actions

  February 28, 2003 at 2:25 am

  #450004

  Thanks Phil.

  I don't think this is relevant to our problem as we're not using openxml rowset provider.

  For info, we're on sql server 2000 sp2 (because of the published problems with dts in sp3).

  As a workaround, and probably the permanent solution, we're using bcp at the moment.

  Thanks again

  Andy