sql server dts: DTS Package Fails With This Error: Line 1: Incorrect syntax near ' -- sql server dts

DTS Package Fails With This Error: Line 1: Incorrect syntax near '

Warren
4/13/2006 5:01:02 AM

sql server dts:

Hi,

Has anyone seen this error and know how to correct it?

Line 1: Incorrect syntax near '/'. [SQLSTATE 42000] (Error 170) The
identifier that starts with
'Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF820D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0F9136409AF1EF80F28D2F75CCB063'
is too long. Maximum length is 128. [SQLSTATE 42000] (Error 103). The step
failed.

**The above referenced number is the number referenced in the DTS job step
#1 as:
DTSRun
/~Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF820D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0F9136409AF1EF80F28D2F75CCB06364155A67FC3F53A636D8D82F1BF0F310179B10952DB99756086EF1813A1F6FF6EA2C1528117E6EFF2588B40915703ABA1953AC7FF001F348A88BDF043A94CCB2C0CCD41C0A82D7E8E4D340040F825EA6EBA04D467B3C4C24D6DFFBEB6E4AF0148E6FE2358

So it looks like this the the internal SQL # to identify this job. How can
I make the job run? Any ideas appreciated.

Thanks,

RE: DTS Package Fails With This Error: Line 1: Incorrect syntax near '

Jeff Ericson
4/13/2006 7:08:02 AM

I would regen the string by rescheduling the opackage or using dtsrun gui

[quoted text, click to view]

Re: DTS Package Fails With This Error: Line 1: Incorrect syntax near '

Allan Mitchell
4/13/2006 7:05:38 PM

Hello Warren,

Have a look here, hopefully it will help

http://www.sqldts.com/default.aspx?301

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.