Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS, Excel, and DT_NTEXT Expand / Collapse
Author
Message
Posted Thursday, September 18, 2008 5:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205


I have written an aricle on this. Kindly check it.



I have written an aricle on this. Kindly check it.



http://venkattechnicalblog.blogspot.com/2008/09/excel-column-is-greater-than-255-in.html



Regards,
Venkatesan Prabu .J


http://venkattechnicalblog.blogspot.com/2008/09/excel-column-is-greater-than-255-in.html



Regards,
Venkatesan Prabu .J


Thanks and Regards,
Venkatesan Prabu, :P
My Blog:

http://venkattechnicalblog.blogspot.com/
Post #571635
Posted Tuesday, August 11, 2009 7:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 24, 2011 12:00 PM
Points: 7, Visits: 27
If you want to create a cplumn that has more than 255 characters, you can use TEXT as its datatype (not sure if it works for more that 8000 Characters).

For eg. While creating Table in Execute SQL Task, you code looks somewhat like this:
Create Table 'Table Name' {
'Column1' Varchar(80),
'Column2' TEXT
}

When you are writing this column to Excel File, you need to use a Data Converstion Task inside Data Flow Task and change the column type to Unicode Text Stream
Post #768587
Posted Tuesday, September 24, 2013 7:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:46 AM
Points: 31, Visits: 129
Hi Frank Bazan,

Thanks for your post. This is very helpful to me

Thanks
Jaison
Post #1497845
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse