January 30, 2009 at 8:38 am
I am trying to export the results of a query that has some ntext data in it to a .csv file. I have tried applying the data conversion data flow transformation on it, converting to DT_Ntext or DT+text but the destination file still errors on the conversion. Any ideas?
Thanks in advance
Elliot
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
January 30, 2009 at 9:01 am
Have you tried NVarchar(max)?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 30, 2009 at 9:21 am
GSquared (1/30/2009)
Have you tried NVarchar(max)?
Do you mean converting the source or destination to NVarchar(max)? 'Cause I don't think so its possible to convert to NVarchar(max) in SSIS? Or may be I misunderstood your post?
Elliot,
Can you post the errors you were getting while converting?
--Ramesh
January 30, 2009 at 10:22 am
It was ...
Error at ..The data type for [column] is DT_Ntext, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_Ntext using the data conversion component.
This does not quite make sense as this is for the destinastion file so there os no point in converting it back. I have tried using the data conversion to change to DT_TEXT but with no results.
Thx
ELliot
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply