Copy Objects error ''incorrect syntax''

Question

Post reply

Copy Objects error ''incorrect syntax''

Linda-272642

Ten Centuries

Points: 1100
More actions
August 1, 2006 at 4:31 pm

#69227

I have a job that is executing a copy objects and everytime it runs it tells me that there is incorrect syntax in the script

Does anyone know how to get the script or how to fix it?

I am at my wits end on this

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Linda-272642 Ten Centuries Points: 1100 More actions · Answer 1

here is the actual error I recieve

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)

Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '?'.

Step Error code: 800400AA

Step Error Help File:SQLDMO80.hlp

Step Error Help Context ID:1131

Lance Sanders SSC Eights! Points: 903 More actions · Answer 2

All I've got for now are more questions. This is being launched from SQLAgent, right?

Open the DTS. Select Package->Disconnected Edit. Expand the Tasks collection and click on the Copy task. Find the ScriptFileDirectory attribute & note the directory. Check the server for that path. Are there script files there from the copy operation? If so, parse them individually in QA. Be on the lookout for question marks.

Are there any ActiveX Script or Dynamic Properties tasks preceding the Copy Objects task? Expand the Steps collection & click the step associated with the copy. Does the ActiveXScript attribute for the step contain code?

Let us know what you find & maybe we can get closer to a solution.

Running a profiler trace to look for statements & errors during the job run will also help isolate the statement that's causing the problem.

Linda-272642 Ten Centuries Points: 1100 More actions · Answer 3

we actually just recreated the whole package and it worked. Thanks for your help though. I will keep this mind next time we come across this situation

Linda-272642 Ten Centuries Points: 1100 More actions · Answer 4

Ok we ran into it again. it seems like it only happens on 1 and the 16 of the month. Mid_month and end of month. There is a step in the package that calls another job that runs anothe copy object task.

The source files come up blank when i open them in QA. And the rest of the tasks are either sql tasks or copy column