Post reply

data source column is too larg for the specified buffer size when importing the data from sql table to excel

  • February 6, 2008 at 4:33 am

    #69780

    I am trying to insert data from SQL Table to Excel file by using DTS.

    The Excel file is in my C drive.

    The SQL Table contains one field whose datatype is text. This field contains a huge data. While importing data to my excel file i am receiving below error :

    "data source column[13][Column_Name] is too large for the specified buffer size when importing the data from sql table to excel"

    In destination tab of "Transform Data Task Properties" window shows all the columns of excel file with datatype varchar for all. I want to change the datatype of particular field from varchar to Text. How to do this?

    If anyone has the idea of it please help me in this. Its very urgent.

    Thanks in advance.

    Harsha

  • February 6, 2008 at 8:32 am

    #775629

    Excel data cells can only accomodate 32767 characters. You're going to have to break that up if you plan on putting that into Excel.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply