Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 problem using bcp

Author  Topic 

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-01-04 : 17:07:31
Hi is this correct in command prompt:
bcp myDatabase.dbo.FileListInput in C:\Dev\Mosaik\SQl\filelist.csv -t -c -UmyDomain\myUsername -SmyServerName
also what credentials, security access and permissions should the user myUsername have on the sql server instance and on the database myDatabase

Thanks a lot

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-04 : 20:00:46
if you want to use windows auth, then it should be like this:

bcp myDatabase.dbo.FileListInput in C:\Dev\Mosaik\SQl\filelist.csv -T -c -SmyServerName


www.elsasoft.org
Go to Top of Page
   

- Advertisement -