There is no syntax, it's a dts package that I'm assuming has generated a
script somewhere to copy the set of database tables from one db to the
other. All I've done is select the source, destination and checked the
tables I want transferred. Is it possible to use qa to view dts scripts?

I've saved the package as a vb script but there's just a couple of objects
that get their properties set, then the Execute method is called. No sql
anywhere.

It could be a table name or column name that has a reserved word for a name,
but I run this type of package for several databases, which are all the same
fundamental design and haven't seen this error before, I scanned the table
designs but haven't spotted anything. The table transfer completes then the
error occurs somewhere in the cleaning up afterward, it may be writing the
foreign keys etc. If I could get a look at the 'ON' statement it's
complaining about I can make the necessary adjustments.

-----Original Message-----
From: Beal, Jeremy [mailto:[Email Address Removed] Friday, 23 January 2004 1:11 AM
To: Bart Hayes; LazyDBA.com Discussion
Subject: RE: DTS Error

Bart,

Have you used the Query Analyzer to check your syntax?

jeremyb

-----Original Message-----
From: Bart Hayes [mailto:[Email Address Removed]
Sent: Wednesday, January 21, 2004 7:17 PM
To: LazyDBA.com Discussion
Subject: DTS Error
Hi,

I have DTS package copying all the database tables from a remote database to
our local version. It seems to work fine, but at the end fails, the cause is
apparently 'incorrect syntax near the keyword ON'. Can anyone tell me how I
can get a look at the script that the task generates? I haven't supplied any
scripts, just clicked the appropriate options. I imagine a join statement of
some kind is failing but I have no idea why.

Any suggestions appreciated.

Thanks

Bart
MS Sql Server LazyDBA home page