Did you ever find a solution to your problem?

Dumb question but where do I put the Script Component in the Data Flow?:unsure:

Don't I need to specify what to do with all of the columns?

Jack Corbett (3/19/2012)

---

Here's...

Dumb question but what what is the best way to edit the XML?

NVARCHAR(2000) does not work.

I suspect that there is an issue with the data.

SQL Server does not like something about a particular record.

I need to figure out how to redirect the...

Jack Corbett (3/11/2008)

---

I suggest configuring the error output to redirect row and outputting the data to a table or file so you can see what row(s) are being...

I...

I will give it a shot.

GRussell31 (3/19/2012)

---

Hi,

From what you have described I don't think this is an issue with the size of the fields but with the data itself and that SQL cannot convert the...

I'm getting the same error on a different table.

It get the following truncation error:

[ctl_additional_interest [1]] Error: The "output column "DESC0LINE1" (70)" failed because truncation occurred, and the truncation row...

Thanks!.

I need to split the package for sure.

I'm going to open another post asking if there is a way to edit the package in the DTS equivalent disconnected edit mode.

Thanks again Pam.:-)

Pam Brisjar (3/12/2012)

---

Data Warehousing | Integration Services

http://www.sqlservercentral.com/Forums/Topic1265061-364-1.aspx

basic pseudocode:

INSERT INTO [table1]

(

...

Thanks.:-)