Data transfer for text column | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data transfer for text column

Data for text type columns is not transferred when I do the data transfer from DB to another. Do we have any fix for this? Ashish Johri
How you are copying the data? I don’t think there is any issue copying text data from one db to another…. MohammedU.
Sorry I am late to respond your mail. Actually I was trying to copy data from DB to xl sheet. Whenever any column in the table is ‘text’, I get the error as follows. In this particular case the column "Note" is text type column. Error 0xc02020f6: Data Flow Task: Column "Note" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component "Destination – Sheet1$" (61)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard) Regards,
Ashish Ashish Johri
For text data type BCP is only best way to go as far as my experienece is concerned. If this is an ongoing requirement then suggestion is to keep that table on seperate filegroup and transfer the filegroup between the servers. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following.. SQL Server 2005 Books Online
Cannot convert between Unicode and non-Unicode strings MohammedU.
Moderator All postings are provided “AS IS” with no warranties for accuracy.