Tags: address, batchsize, dts, dtsrun, error-, incorrect, load, mysteriously, onstart, package, programming, server, sql, syntax, working
80040E14 - Incorrect syntax near 'BATCHSIZE'
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 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
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
I am not getting any useful hits when I search the Microsoft pages or
Leave a comment...
- 0 Comments