• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

DTS error trying to copy text field

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?

  • 2
1 Solution
Are we talking SQL to SQL?  I've heard of this when going from Access to SQL.
Aneesh RetnakaranDatabase AdministratorCommented:
johnnyg123Author Commented:
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!
johnnyg123Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now