Tags: address, batchsize, dts, dtsrun, error-, incorrect, load, mysteriously, onstart, package, programming, server, sql, syntax, working

80040E14 - Incorrect syntax near 'BATCHSIZE'

On Programmer » SQL

936 words with 0 Comments; publish: Thu, 29 May 2008 00:36:00 GMT; (20045.90, « »)

I am having problems with a DTS package which has mysteriously stop

working on our test server with the error:-

DTSRun OnStart: Load Address data

DTSRun OnError: Load Address data, Error = -2147217900 (80040E14)

Error string: Line 4: Incorrect syntax near 'BATCHSIZE'.

Error source: Microsoft OLE DB Provider for SQL Server

Help file:

Help context: 0

I have copied

(a) the DTS package file

(b) the database files (detach - reattach)

(c) the address text files (i..e the flat files to be loaded into the

database)

to the development SQL Server instance (on a seperate machine) the load

works fine here!

This used to work, and still does work on the development server, this

should narrow the problem down to some configuration aspect on the test

server.

I am not getting any useful hits when I search the Microsoft pages or

via Google.

All Comments

Leave a comment...

  • 0 Comments