FreeTDS Development Group

[bpollard AT micron.com]

> ______________________________________________ 
> From:         bpollard  
> Sent: Tuesday, September 20, 2005 3:07 PM
> To:   
> Cc:   Subject:        freebcp is free but ....
> 
> Has anyone used freebcp on Solaris?  I am migrating a fairly large job
> to MSSQL and I did not want to re-write it in perl, so I took the
> shell code and replaced isql with tsql, then found freebcp to replace
> bcp.  The only problem is that freebcp does not load the data nor
> produce an error file.  Any ideas?
> 
> unix$ cat /var/tmp/test.out
> 1 2
> 3 4
> 5 6
> 7 8
> 9 0
> 
> MSSQL$ create table test (a char(10), b char(10))
> MSSQL$ grant insert on test to public
> 
> /mu/sdk/freetds/0.61.2/bin/freebcp temp_bcp..test in /var/tmp/test.out
> -c -b 2 -UDBA_SA -Ppwdnotlisted -SBOMSSDEVL19 -e /var/tmp/test.err
> 
> 
> Starting copy...
> 
> 0 rows copied.
> 
> unix$ ls -ltr /var/tmp/test.err
> /var/tmp/test.err: No such file or directory
> 
> Brian D. Pollard
> Database Systems Administration Team Lead
> Micron Technology, Inc. Boise, Idaho
> 208-368-5437 (voice)
> 208-368-5000 enter #7073629  (pager)
> 208-363-4114 (fax)
> 
> 
>