Results 1 to 2 of 2

Thread: SQL Server DTS

  1. #1
    Join Date
    Aug 2004

    Unanswered: SQL Server DTS

    I am using SQL Server Data Transformation Services to import data from a MS Access DB to a SQL Server DB.

    One of the fields of the SQL Server table is of type varchar with size set to maximum of 8000.

    However, when I import the data I get this error:

    Error at source for number 932. Errors encountered so far in this task: 1.
    Data for source column 4 ('Solution') is too large for the specified buffer size.

    Solution is the name of the column in the SQL Server table.

    I don't know what I can do to correct this as I have set the field to the maximum size!

    Any suggestions?



  2. #2
    Join Date
    Apr 2003
    Washington DC area

    Red face Source Error

    Looks like you have bad data in record:Error at source for number 932 of the source table. Make it easy on yourself. drop it in exel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts