I am attempting to copy a table from one SQL 2000 server to another. I am
using the Copy Objects/Replace Existing options. The task runs for about 15
seconds and then it fails with an error "Line 2: Incorrect syntax near
'Advisory'"

Line 2 of what? Where can I find the script or whatever it is referring to?
I do have another table [CG Advisory Board] and I expect it has something to
do with that table? [CG Advisory Board] has a FK pointing to the table I am
trying to copy.

Wayne

Are you using the wizard and the default options? If so, try
going to the options and deselecting the primary and foreign
keys.

-Sue

On Mon, 15 Nov 2004 17:54:38 -0700, "Wayne Wengert"
<wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote:

Thanks for the suggestion Sue but I get the same error even after turning
off that option.

Wayne

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

So I take it you did this using all the defaults with a Copy
SQL Server Objects task? Remove the rest of the options
except for use quoted identifiers and make sure you are also
deselecting Include All Dependent Objects.
You may also want to look in the Script File Directory for a
log file on the process - ending with .LOG - that should
give you more information on what the error is about.

-Sue

On Tue, 16 Nov 2004 09:30:34 -0700, "Wayne Wengert"
<wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote:

Thanks... I'll try that

Wayne

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

Where do I find that Script File Directory? I do not own the server - I have
an account with just my database available to me.

Wayne

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

I believe it defaults to a local directory relative to the
client. On the Select Objects to Copy window, its on the
bottom - Script File Directory.

-Sue

On Thu, 18 Nov 2004 20:06:39 -0700, "Wayne Wengert"
<wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote:

Thanks Sue. I found the Log file but it really doesn't include any helpful
information. Entries like:

::Error::
In file in statement on line 0
Transfer Status: Transferring Data: (Table '[dbo].[Judges]')
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.

::Error::
In file in statement on line 0
Transfer Status: Transferring Data: (Table '[dbo].[JudgesAssociations]')
[Microsoft][ODBC SQL Server Driver]Communication link failure


Don't tell me much and I can assure you, the communication link is just fine

Thanks for the advice.

Wayne


"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

And this is the entire log for a package that fails with:
"Line 2: Incorrect syntax near 'Advisory'"
And this is from attempting to copy one table? Why are two
other tables listed which don't appear to be the table you
were originally trying to copy.
The problems and what exactly you are doing on this one seem
to be quite different from the original post.
On a communication failure, it's can be many different
things but it's important to remember that DTS is a client
tool and communication failures are a fact of life. Network
burps and glitches happen on all networks so you may not
necessarily want to rule that out. It may not be the case
but you'd want to be careful in assuming it absolutely is
not the issue.

-Sue

On Fri, 19 Nov 2004 11:03:45 -0700, "Wayne Wengert"
<wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote:

The original copy had about 5 tables involved. I just clipped a portion of
the log - all of the entries were very similar. As for the network failure,
I have trouble believing that I can run all day without problems but when I
copy a specific table between 2 servers the network always fails!!!

I do appreciate all the help and advice, I am just not very impressed with
DTS. I ended up writing a small VB.NET window app that does the copy just
fine. I tried it 3 times so far and every time it ran without error.

Wayne

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote