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

Posted on 2007-10-10
Last Modified: 2009-01-26
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

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
Question by:cpctech
    LVL 14

    Expert Comment

    You don't specify a server name in this. Try adding one in.
    LVL 2

    Author Comment

    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.
    LVL 14

    Accepted Solution

    That'd do it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now