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 http://dineshasanka.spaces.live.com/