importing .dat file with varing columns | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

importing .dat file with varing columns

<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=’:p‘ />] <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.
actually,i already read online assembled with SQl Server 2005 but u unable too resolve this problem.
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.
]]>