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.
| Author |
Topic |
|
MzzzShay
Starting Member
4 Posts |
 Posted - 2011-09-13 : 11:51:20
|
| I have a txt file that I am trying to import into SSME using the bcp command in the command prompt window. My command is:bcp tempdb.dbo.Sales in'C:\desktop\Sales.txt' -T -cWhen I execute it the code text file opens in notepad and does not import SSME. Please help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MzzzShay
Starting Member
4 Posts |
Posted - 2011-09-13 : 18:39:02
|
| I tried that and now I am getting this error message.SQLState = $0002, NativeError = 208Error = [Microsoft][SQL Server Native Client 10.0][SQL Server] Invalid obeject name 'DimProducts'. |
 |
|
|
MzzzShay
Starting Member
4 Posts |
Posted - 2011-09-13 : 18:40:13
|
| P.S. I was at work when I put my first post and couldn't remember the name of the table. It is DimProducts not Sales. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MzzzShay
Starting Member
4 Posts |
Posted - 2011-09-13 : 19:28:19
|
| I did create the tables. I figured it out though. I have both sql server 2008 and sql server 2008 express and I was not connecting to the express version that my table exists on. Thank you for your help though. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
bcp utility not working correctly
Tara Kizer