DTS error trying to copy text field

Posted on 2006-05-22
Last Modified: 2007-12-19
I am trying to copy data from a view on one database to a table located on a different table using a dts package transform data task.

As soon as it tries to a copy a field that is defined as text (does have more than 4000 characters) I get an error that says too large for buffer size.

Any ideas?

Question by:johnnyg123
    LVL 3

    Expert Comment

    Are we talking SQL to SQL?  I've heard of this when going from Access to SQL.
    LVL 75

    Accepted Solution


    Author Comment

    sorry I forgot to mention I am talking about a sql server view and a sql server table.

    Text fields are such a pain.

    Unfortunately I can't change the table definition as it is a vendor table.

    Perhaps I need to copy into a temp table?

    Please help!

    Author Comment

    I didn't mention the fact that I was going from a sql server view to a sql server table so I wanted to award points  to aneeshattingal for sending the link about going for access to sql server

    however, since it really didn't solve my problem (my bad)..I didn't award a grade of A

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now