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 JohriHow you are copying the data? I don’t think there is any issue copying text data from one db to another…. MohammedU.
Moderator
SQL-Server-Performance.com
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
http://www.SQL-Server-Performance.Com
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..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=64475&SiteID=1 SQL Server 2005 Books Online
Cannot convert between Unicode and non-Unicode stringshttp://msdn2.microsoft.com/en-us/library/aa337316.aspx http://msdn2.microsoft.com/en-us/library/ms141683.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>