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.
http://sql.itags.org/q_sql_949.html
All Comments
Leave a comment...
- 0 Comments