Viewing 10 posts - 1 through 10 (of 10 total)
April 22, 2018 at 10:44 pm
The txt file was generated by a software package that I am unfamiliar with.
Not sure why the format file suggests lengths of 400, and the create table says 200...
April 22, 2018 at 8:25 pm
I used Script Table as Create to Clipboard, then pasted this :
USE [Rest01]
GO
/****** Object: Table [dbo].[RestCreditors] Script Date: 23/04/2018 2:12:38 p.m. ******/
SET ANSI_NULLS...
April 22, 2018 at 8:13 pm
Because I have 6 more text files, and would like to exclude certain fields going to the table.
April 22, 2018 at 8:09 pm
OK, changed last line to :
29 SQLCHAR 0 400 "/r/n" 29 ChangeDate SQL_Latin1_General_CP1_CI_AS
still same EOF error
April 22, 2018 at 8:05 pm
It was generated using the format option of the bcp command
BCP Rest01.dbo.RestCreditors Format null -T -c -S ".\SQLDEVELOPMENT" -r/r -t/t -f "bcpCrs.fmt" -e P:\BCPErrors.txt
April 22, 2018 at 7:53 pm
Sorry - it looks like it only allowed one attachement.
Here it is
9.0
29
1 SQLCHAR 0 400 "/t" 1 CreditorName SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 ...
April 22, 2018 at 7:52 pm
Viewing 10 posts - 1 through 10 (of 10 total)