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