<hr noshade size="1"><b>importing .dat file with varing columns in each row of file </b> <br /><br />Hi fellows [<img src='/community/emoticons/emotion-1.gif' alt='' />], <br /> I am facing a problem in importing dat file. A .dat looks like below <br /><br />"1","2","3","4","1"<br />"1","2","3","4","2"<br />"1","2","3","4","3"<br />"1","2","3","4","4"<br />"1","2","3","4","5"<br />"1","2","3","4"<br />"1","2","3","4","7"<br />"1","2","3","4"<br />Sql Server 2005 import wizard report a warning that there are some rows with less number of columns or with incomplete data rows.[}<img src='/community/emoticons/emotion-1.gif' alt='' />] It also merges the row with less number of columns to previous one with full number of columns.[:0]<br /><br />I never fond this error whenever i worked import wizard of Sql Server 2000.[<img src='/community/emoticons/emotion-4.gif' alt='' />] <br /><br />Can any one can guide me to overcome on this problem.[?]<br /><br /><br />
Refr to books online about setting up import column information. 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.
Have you specified anything on the dataflow task? 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.
no i didnot mention any kind of transformation through script or properties. u can also check this just copy paste the data into a file which i mention and try to load data in ur practice data it will not work and u can also see the hell of warning and preview of data.