Chris Quinn-821458
Hall of Fame
Points: 3192
More actions
November 9, 2009 at 4:46 am
#1076588
You need to change the extended properties on your Excel connection - as a default excel will check the first 8 (ish) rows of data to guess datatype etc.
http://msdn.microsoft.com/en-us/library/ms141683.aspx
http://ganeshprof.blogspot.com/2007/10/excel-connection-in-ssis.html
chrismgarvey
SSC Eights!
Points: 834
November 10, 2009 at 10:23 am
#1077380
Hi Chris,
Many thanks for your suggestion. This solved my issue by changing the value from '6' to '16'.
Regards,
Chris
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply