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\delet able_files \FTL_Payro ll_File_10 092007.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
C:\>bcp dts_working_db.FTL_Payroll
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
You don't specify a server name in this. Try adding one in.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.