Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS Bulk Insert issue

Author  Topic  Eranna Starting Member 2 Posts Posted - 2009-07-24 : 12:47:17 Hi, I am re writing Bulk insert commands written in SQL 2000 sproc in SSIS 2005 bulk insert task. I generated format file using bcp and using that format file in my task ( I even tried without format file) . But i am getting "unexpected end of file eror". I doubt this is because of the delimiters used in the data file but i am not able to recognize what they are. Could someone help me in identifying the data file delimeters and how to solve this issue. Here is the sample of the data file 0000000000 HEADER 1111111100000000 000000000000000000000000000000000 000 * 1111111111 AAAAAA 1111111100000000AAA AAA AAAA000000011100000011100111106000000CCCCCCC 000 * 9999999999 TRAILER 1111111100000000 000000000000000000001020000000000 000 * Note that all the data files have HEADER and TRAILER as first and last rows respectively. The stars denote the end of the line( this is same as in the file. Thank you very much, Eranna