Copy Direction Must be in, out or format

[Dhyerwolf]

I wrote a program in early 2010 that ran a command line function that pulled data from SQL Server 2005. The program worked at the time, but does not seem to work now (for various reasons, it was not used for about a 1 year).

BCP "EXEC emdb..Patch2" QUERYOUT D:\shares\patch2.txt -S GEN-SERVER\EMMSDE -t "~" -c

The error message says "Copy direction must be in, out or format." I'm trying to figure out what I need to change to make this work; Please note that I don't actually have any programming background (it was extensive research into books that my boss no longer has). Thanks,

 

[SkipVought]

Dhyerwolf, (Programmer)

"...I don't actually have any programming background..."

Which statement is true?

 

[Dhyerwolf]

I'm a "programmer" on this site because I have to pick a category and "befuddled" wasn't an option. I've never taken a programming class and have very minimal self taught knowledge that I haven't put to use for half a decade.

 

[jbenson001]

Google is your friend. Try this link and read through the whole thread:

http://www.sqlservercentral.com/Forums/Topic457995-149-1.aspx

-- version/permissions issue?