tag:blogger.com,1999:blog-6357505892638015674.post4373261992658555665..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: excel column is greater than 255 in ssisUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6357505892638015674.post-9537545757893267132014-01-29T10:37:58.369-08:002014-01-29T10:37:58.369-08:00Thanks Venkat for your help - This is amazing
--...Thanks Venkat for your help - This is amazing <br /><br />--SaurabhAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-13977446459326262712013-06-21T08:27:28.697-07:002013-06-21T08:27:28.697-07:00Thanks for this..
This was my problem. First 8 row...Thanks for this..<br />This was my problem. First 8 rows had text which was <255 characters<br />2. SSIS has an inbuilt logic to scan the data in the spread sheet. It will scan the first 8 rows and based on that it will written a logic to build the table's logic for the package. If your lengthy data in not in the 8 row then your ssis wont respond it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-6622690312203762062011-06-27T09:57:22.494-07:002011-06-27T09:57:22.494-07:00Thank you, this was very helpful. My import to SQ...Thank you, this was very helpful. My import to SQL Server from an Excel spreadhsheet worked perfectly with this solution.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-54276569281004491182010-11-25T02:03:48.354-08:002010-11-25T02:03:48.354-08:00It works very well. Thanks a lot for your comment,...It works very well. Thanks a lot for your comment, it was very usefull.<br /><br />Thanks again!Fulgenciohttp://www.blakescience.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-40176767749484196542009-02-27T10:37:00.000-08:002009-02-27T10:37:00.000-08:00Could you elaborate on your second solution? what ...Could you elaborate on your second solution? what do you mean by Preparation SQL task query? I am also facing this issue for both imports and exportsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6357505892638015674.post-19077534064339231362008-10-23T03:02:00.000-07:002008-10-23T03:02:00.000-07:00Very useful Venkat.I had face the problem one year...Very useful Venkat.I had face the problem one year before.Now i got the solution..Thank u for your solution..i hope it will lot of people.Murali.Mhttps://www.blogger.com/profile/08959603324111675356noreply@blogger.com