• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

using bcp in a batch file with Management Studio Express 2005

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?

Thanks.
0
-Dman100-
Asked:
-Dman100-
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you show the usage and especially, the error, please?
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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