Learn how to a build a cloud-first strategyRegister Now


DTS error trying to copy text field

Posted on 2006-05-22
Medium Priority
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
  • 2

Expert Comment

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

Accepted Solution

Aneesh Retnakaran earned 1500 total points
ID: 16739260

Author Comment

ID: 16742244
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

ID: 16745455
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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

810 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