Hi, i wanted to ask on the same context of bcp...i m trying to insert two rows into a table using the bcp command prompt and the bcp file looks as follow(format.fmt): 7.0 3 1 SQLCHAR 0 4 ""," 1 numbers 2 SQLCHAR 0 15 """ 2 values 3 SQLCHAR 0 2 " " 3 finish and the input file has the following contents 1234,"other" 5678,"column" now when i m running the command as bcp master.dbo.two_column in c: empinput.txt -fc: empformat.fmt -Sserver -Uuser -Ppasword -T it gives me the error as sqlstate 07009 with native state =0 and the error as = [Microsoft][SQL Native Client] Invalid descriptor index i m using sql server 2005 (YUKON)...can anyone pleaseeeeeeeeeeeeee tell me how can i solve this problem?????????????????so that i can insert these rows into my table two_column.... thanks ...pleaseeeeeeeeee help me....
Your format file is not formatted correctly. The number of columns, the version and the delimiters are wrong. Use this: 8.0 2 1 SQLCHAR 0 4 "," 1 numbers 2 SQLCHAR 0 15 " " 2 values And you data file should be like this: 1234,other 5678,column Nathan H.Omukwenyi
Have you checked SQL 2005 books online for formatfile option topic. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.