July 6, 2009 at 8:54 am
Hi All,
I have a xml file to import into SQL server 2005. Now the xml file has a description section which holds th email id of a person. The description is a long paragraph and nvarchar(4000) does not work becoz the text is getting truncated . As a work around to this issue i replaced the nvarchar(4000) with ntext. But now i have another problem . I have to extract the email id from the description and store it in a column in a table . I cannot use string functions now , please help me in finding a solution to this issue.
July 6, 2009 at 9:04 am
In SQL Server 2005 why are you using NText instead of Nvarchar(max) which can grow to 2gig? If your database is from 2000 then change your compatibility to 90 so you can use Nvarchar(max).
Kind regards,
Gift Peddie
July 6, 2009 at 9:28 pm
I am using sql server 2005 . The problem is I have to import this xml file using ssis. But in the list of data types (when i choose xml source in ssis) nvarchar(max) is not available , so I have to go for ntext otherwise the text gets truncated
July 8, 2009 at 4:18 pm
I think you are not getting Nvarchar(max) because you may have to convert to Nvachar or import it as xml and then do a convert. Here is another option from Microsoft.
http://blogs.msdn.com/mattm/archive/2007/12/11/using-xml-source.aspx
Kind regards,
Gift Peddie
July 8, 2009 at 4:19 pm
I think you are not getting Nvarchar(max) because you may have to convert to Nvachar or import it as xml and then do a convert. Here is another option from Microsoft.
http://blogs.msdn.com/mattm/archive/2007/12/11/using-xml-source.aspx
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply