How to load csv file into table?

[pmcmicha]

How do I load a csv file into a table without the transaction log filling up? I only have so much space allocated to the log portion of the database and it fills up when I try to bcp in a csv file.

Sybase Server 11.9.2

Thanks in advance.

 

[sybaseguru]

Use bcp and set the batch size like below
bcp <data_base>..<table_name> in <file_name> -t, -U<user_name> -S<server_name> -P<password> -b<batch_size>

For example with -b1000 will commit every 1000 records so your transaction will not fill in. Obviously you can change the -b size

Good luck