Using bcp to import data error message

Question

Using bcp to import data error message

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

You don't need to prefix with the drive?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

mrdenny SSCrazy Points: 2898 More actions · Answer 2

No. BCP will work with relative paths, as long as you are running the command in the correct path.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Just my personal preference.

I would prefer to document the Path in the Statement.

I would try to avoid having to CD to the path where the destination file exists every time that I want to execute BCP.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

mzzzshay (9/8/2011)
I have to use bcp to import a text file from my computer. I am getting the above error and not sure why. Here is my code and any help is appreciated.
bcp tempdb.dbo.DimProducts in
"c:\Users\Shay\Documents\DimProducts.txt" -T -c

Just out of curiosity why are you creating objects in the System Database Tempdb? :w00t:

If you had provided your schema and sample Data you would have been provided a tested solution already.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

mzzzshay Old Hand Points: 385 More actions · Answer 6

mzzzshay

Old Hand

Points: 385

September 16, 2011 at 12:39 pm

#1382726

I have it figured out. Thanks anyway!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

mzzzshay (9/16/2011)
I have it figured out. Thanks anyway!

So what was the problem?

If you had provided information requested this would have been resolved a week ago. 😀

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/