I'm working on a homework problem that requires the creation of a new table in the Northwind database. Once the table is built I have to use the bcp utility to import a tab delimited file. However whenever I try to run the commands I get the following error message:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
Here is my bcp command:
bcp Northwind.dbo.NewEmployees in C:\NewEmployees.txt -S localhost\BILL-PC -T -c
Below is the create table script:
CREATE TABLE [dbo].[NewEmployees](
[EmployeeID] [int] NOT NULL CONSTRAINT [PK_NewEmployees] PRIMARY KEY,
[LastName] [nvarchar](20) NOT NULL,
[FirstName] [nvarchar](10) NOT NULL,
[Title] [nvarchar](30) NULL,
[TitleOfCourtesy] [nvarchar](25) NULL,
[BirthDate] [datetime] NULL,
[HireDate] [datetime] NULL,
[Address] [nvarchar](60) NULL,
[City] [nvarchar](15) NULL,
[Region] [nvarchar](15) NULL,
[PostalCode] [nvarchar](10) NULL,
[Country] [nvarchar](15) NULL,
[HomePhone] [nvarchar](24) NULL,
[Extension] [nvarchar](4) NULL,
[Notes] [ntext] NULL,
[ReportsTo] [int] NULL,
[PhotoPath] [nvarchar](255) NULL
)
I'm having a hard time figuring out the problem and would appreciate any help you guys can provide.
BCP issue
Posted - 2008-12-20 : 01:28:45
