I am using BCP with SQL 2005 to import data into a table. I am able to use BCP to download from SQL to txt file but having issues uploading data into a table. I get an error msg - "Cannot Open database "DBTest" requested by the login. I am using the same login ID for downloading and it works just fine but not when I'm uploading to SQL. Server is on a VM image. Here is my code -
bcp DbTest.dbo.testTable in c:\bcp\testTable.txt -S test -C -T -f c:\bcp\testTable.fmt
Any help on this would be greatly appreciated.