BCP in MS SQL 6.5( missing some rows)

[Ali Alhussein]

hi, I use bcp code to import a text file from an ftp server into a table in sql server 6.5. I realized that not all rows are imported. I could not think of any reason why not all rows are imported. Can anyone explain the reason for causing this ..
here is my bcp code for your information:

Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfile ablename.fmt /Servername /Usa /Password /b250000 /a8000"

Note that the /b250000 MEANS batch size:# of rows per batch
/a8000 Means Packetsize: ?

thanks for your help

regards

Ali

[Gregory]

try to use '/e' option to save bcp error log into file....


------------
Ali Alhussein at 3/11/99 2:37:04 PM

hi, I use bcp code to import a text file from an ftp server into a table in sql server 6.5. I realized that not all rows are imported. I could not think of any reason why not all rows are imported. Can anyone explain the reason for causing this ..
here is my bcp code for your information:

Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfile ablename.fmt /Servername /Usa /Password /b250000 /a8000"

Note that the /b250000 MEANS batch size:# of rows per batch
/a8000 Means Packetsize: ?

thanks for your help

regards

Ali

[Ali Alhussein]

Hi, I used the /e in my bcp code. yet did not get all the rows from the main frame into the sql talbes... here is the case I have 11 million rows in an ftp server I use this code to bcp into sql server can anyonecheck if this code is good for the process, I am missing one million row in the bcp process and do not know why??? I put the /e to see if there is any error but could not see any error file in my hard drive?
Please check it out and let me know

regards
Ali


------------
Ali Alhussein at 3/11/99 2:37:04 PM

hi, I use bcp code to import a text file from an ftp server into a table in sql server 6.5. I realized that not all rows are imported. I could not think of any reason why not all rows are imported. Can anyone explain the reason for causing this ..
here is my bcp code for your information:

Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfile ablename.fmt /Servername /Usa /Password /b250000 /a8000"

Note that the /b250000 MEANS batch size:# of rows per batch
/a8000 Means Packetsize: ?

thanks for your help

regards

Ali