SQL Server Performance

importing .dat file with varing columns

Discussion in 'SQL Server 2005 Integration Services' started by adrshen, Nov 29, 2006.

  1. adrshen New Member

    <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 />
  2. satya Moderator

    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.
  3. adrshen New Member

    actually,i already read online assembled with SQl Server 2005 but u unable too resolve this problem.
  4. satya Moderator

    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.
  5. adrshen New Member

    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.


Share This Page