DTS

  • I am trying to load the excel file to a table using DTS. I am getting the following error.

    General Error - 2147217187

    Too large for specified buffer size

    How to increase the buffer size for DTS.

    Advance Thanks for your help.

    email address

    rajeshkumar.vs@mphasis.com

  • In your DTS import you can specify the target table which unless you built will build for you. Using the Import/Export Wizard, when you get to "Select Source Tables and Views" screen in the grid slid over to transform for the items selected and check the output size for the column. You should be able to adjust there.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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