[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3247
  • Last Modified:

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
0
cpctech
Asked:
cpctech
  • 2
1 Solution
 
twoboatsCommented:
You don't specify a server name in this. Try adding one in.
0
 
cpctechAuthor Commented:
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.
0
 
twoboatsCommented:
That'd do it.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now