Link to home
Start Free TrialLog in
Avatar of cpctech
cpctech

asked on

BCP Help - Error = CTLIB Message: - L6/O8/S5/N3/5/0:

Here is my BCP command

C:\>bcp dts_working_db.FTL_Payroll_File out "\\shouts01\DTS_WORK\deletable_files\FTL_Payroll_File_10092007.csv" -c -t, -T

Here is the output in the command window when executed at the server

Password:
CTLIB Message:  - L6/O8/S5/N3/5/0:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Establishing connection failed.

I have 15 DTS packages issuing the same command, but for some reason this one will not work.
I just need a slap in the right direction to get this functioning
Avatar of twoboats
twoboats

You don't specify a server name in this. Try adding one in.
Avatar of cpctech

ASKER

Found the issue.

IT installed a set of Sybase drivers and it changed the enviroment variable to point to sybase's bcp and not SQL Server's bcp.
ASKER CERTIFIED SOLUTION
Avatar of twoboats
twoboats

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial