Hi,
First of all, I'm pretty new to SQL Server (insert groan
here).
I've been left with the task of running some
reports which hinder on the successfull completion
of BCP. I'm getting an error "Bcp: Unable to open
host data-file". The docs were of little help. I'm
hoping this is something obvious.
More Info:
It has been working fine for 2 months now, thus I assume
is is some server setting or something. It also
seems to suggest that for some reason, the table is
not being opened, even though I am logging in as
SA.
We are using a batch file to fire BCP as below:
echo off
REM Loads the ADMIT Data from Charter
k:\binn\bcp SA_DB..ADMITS in i:\ADMT%1.TXT /c /t, /r\n /Ssaidata /U%2 /P%3
The params are passed in like such:
loadadmt.bat 0696 sa
Any clues?
Thanks, In Advance,
Scot.