SQL Server Performance

Transfer of data from flat file

Discussion in 'SQL Server 2005 Integration Services' started by vaddi, May 17, 2007.

  1. vaddi New Member

    hello

    I am trying to create a package. I am executing the query select * from db; in the sql query and sending the result to test.

    While using the flat file connection manager , I pick up the particular flat file and change the column names etc...It throughs me an error:

    The last row in the sample data is incomplete.the column or row delimiter may be missing or the text is qualified incorretly.

    A sample of how my data is in the flat file is:

    Flight_id Flight_Number Starting_From Destination
    --------- ----------------- ----------------- ------------
    1 101 CH LA
    2 102 CH OAK
    3 103 SF TX

    Is there any wrong with the data in the flat file.or do i need to get the data from the database to the flat file in a different way.

    Thanks
  2. dineshasanka Moderator

    what is your row delimiter. is it fixed length or a charactor

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page