using bcp in a batch file with Management Studio Express 2005

Posted on 2007-10-01
Last Modified: 2010-05-18
I have tried using bcp with a batch file to load data from the command shell into SQL Server Management Studio Express 2005, but it fails.

I can use bulk insert and bullk copy in a query window within Management Studio Express 2005 and it works fine.

Will bcp with a batch file not work from the command shell with SQL Server Management Studio Express 2005?

It works fine in SQL Server 2005 or 2000.  Just not in Management Studio Express 2005.  I wasn't sure if this was a limitation?

Question by:-Dman100-
    1 Comment
    LVL 142

    Accepted Solution

    can you show the usage and especially, the error, please?

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now