I am getting this error when I try to export more than 4000 charactor column. "Error DTS.pipeline:The output column has a length that is not valid.The length must be between 0 and 4000" unfortunatly there are no recources availble on this ---------------------------------------- http://dineshasanka.blogspot.com/
Why not use nVarchar in this case? Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.