Hi,

I have a table from which I would like to extract 3 text columns in a copy
column data transformation task. I am getting an error: Unspecified Error.
The max error count is set to 0. The SQL version is SS2000 SP4. The relevant
column schema follows.

CREATE TABLE [dbo].[FSCOTraveler] (
[DivisionCode] [varchar] (4) COLLATE Latin1_General_CS_AS NOT NULL ,
[CoNumber] [varchar] (15) COLLATE Latin1_General_CS_AS NOT NULL ,
[CaRemarks] [text] COLLATE Latin1_General_CS_AS NULL ,
[PcRemarks] [text] COLLATE Latin1_General_CS_AS NULL ,
[PdRemarks] [text] COLLATE Latin1_General_CS_AS NULL ,
[PoDate] [datetime] NULL ,
CONSTRAINT [pkFSCOTraveler] PRIMARY KEY  CLUSTERED
(
 [DivisionCode],
 [CoNumber]
)  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

the simple select statement to load the data matches the table schema. Are
there special considerations to copy tables with text columns?

Any help would be greatly appreciated.

kd