Hi,
Thanks for response. You were only one who answered.
Unfortunately I have this message even I always use format file and I do
not have BLOB.
Who can advise.
Thanks
Yakov



                                                                                                           
              frazerg@t...                                                                            
                                                          To:                                         "sql 
                                                           language" <sql_language@p...>           
              Wednesday May 22, 2002 04:16 AM             cc:                                              
              Please respond to "sql language"            Subject:   [sql_language] RE: Unexpected EOF     
                                                           encountered in BCP data-file                    
                                                                                                           




Yakov
There may be a couple of reasond for this.
1. do you have a BLOB column in the file. Read Technet article Q271344 for
more info:
http://search.microsoft.com/advanced_search.asp?siteid=us/itresources

2. The last row may be trancated or offset. This may be caused by a
delimiter being embedded into a column of data. To avoid this use a Format
File


Another suggestion(but really only for managing the job: substitute the
BCP step with a DTS package.

regards


Greg Frazer


>
Hi,
what do you mean by breaking it into two pieces?
I have a scheduler that manages the jobs execution. After the file from
mainframe in zip format arrives, a job runs to unzip the file and then BCP
runs to populate the table.

Please advise.

Thanks
Yakov