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