Hi All,
I'm trying to bcp in to a table. The struture is something like this:
CREATE TABLE [dbo].[event_report] (
[mslink] [int] NULL ,
[id] [int] NOT NULL ,
[name] [varchar] (20) NULL ,
[report_date] [datetime] NULL ,
[type] [int] NULL ,
[umbrella_report] [int] NULL ,
[status] [int] NULL ,
[remark] [char] (240) NULL ,
[text_1] [varchar] (12) NULL ,
[text_2] [varchar] (30) NULL ,
[created_by] [varchar] (16) NULL ,
[created_date] [datetime] NULL ,
[changed_by] [varchar] (16) NULL ,
[changed_date] [datetime] NULL ,
[org_program_id] [varchar] (50) NULL ,
[chng_program_id] [varchar] (50) NULL
)
GO
and the data I am trying to insert is like this.Its in a batch file:
1008832$1008832$02221.00-002.00$$1501$$976$2216.0-2$$$SYS$2001-09-05 00:00:00.000$epe_prd$2001-10-23 11:24:41.583$MIGRATION$Microsoftr Access
I cannot seem to insert the data. In the dos prompt I'm getting this error:
Microsoft sql server driver unable to open bcp host data-file!
Can someone tell me what I'm doing wrong here?
mkey
I'm trying to bcp in to a table. The struture is something like this:
CREATE TABLE [dbo].[event_report] (
[mslink] [int] NULL ,
[id] [int] NOT NULL ,
[name] [varchar] (20) NULL ,
[report_date] [datetime] NULL ,
[type] [int] NULL ,
[umbrella_report] [int] NULL ,
[status] [int] NULL ,
[remark] [char] (240) NULL ,
[text_1] [varchar] (12) NULL ,
[text_2] [varchar] (30) NULL ,
[created_by] [varchar] (16) NULL ,
[created_date] [datetime] NULL ,
[changed_by] [varchar] (16) NULL ,
[changed_date] [datetime] NULL ,
[org_program_id] [varchar] (50) NULL ,
[chng_program_id] [varchar] (50) NULL
)
GO
and the data I am trying to insert is like this.Its in a batch file:
1008832$1008832$02221.00-002.00$$1501$$976$2216.0-2$$$SYS$2001-09-05 00:00:00.000$epe_prd$2001-10-23 11:24:41.583$MIGRATION$Microsoftr Access
I cannot seem to insert the data. In the dos prompt I'm getting this error:
Microsoft sql server driver unable to open bcp host data-file!
Can someone tell me what I'm doing wrong here?
mkey