DTS To Excel. Column gets truncated.

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  November 18, 2005 at 3:31 am

  #67929

  I have a problem getting a result set out into Excel.

  I am retrieving my data into a static table, and then calling a DTS package to dump the table into an Excel workbook. The DTS DROP's and CREATE's the "table" in Excel first with no problems - but the problem comes when the data is written. One of the columns is a VARCHAR(2000), but this gets truncated as Excel wont allow you to create a column of this size. How do I do it? If I copy and paste the results into Excel, it doesnt truncate the column?

  Thanks in advance.

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  November 18, 2005 at 7:31 am

  #604630

  Make sure the output field is created as LongText, this works for me

  Far away is close at hand in the images of elsewhere.
  Anon.