Solved

XP.CMDSHELL and SQL Server Problem

Posted on 2008-06-25
1
1,081 Views
Last Modified: 2008-07-07
Trying to run the following command in SQL Server 2005:

declare @cmd char(300)
SET @cmd = 'bcp scout.dbo.woheader in c:DCT\SCOUT\woheader.mobile.492 -t^| -Sdevserver\cdi2 -Usa -Pcv1 -c'
EXEC master..xp_cmdshell @cmd

Get the error message:  
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
NULL

Any suggestions ?
0
Comment
Question by:rhhunt
1 Comment
 
LVL 21

Accepted Solution

by:
mastoo earned 500 total points
ID: 21871174
Don't you want another slash like this: C:\DCT\SCOUT  
And that refers to a directory on the database server?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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