Transfer of data from flat file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transfer of data from flat file

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

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