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

#1

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
'Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0 F9136409AF1EF80F28D2F75CCB063'
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
/~Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0 F9136409AF1EF80F28D2F75CCB06364155A67FC3F53A636D8D 82F1BF0F310179B10952DB99756086EF1813A1F6FF6EA2C152 8117E6EFF2588B40915703ABA1953AC7FF001F348A88BDF043 A94CCB2C0CCD41C0A82D7E8E4D340040F825EA6EBA04D467B3 C4C24D6DFFBEB6E4AF0148E6FE2358

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

Thanks,

Warren

#2

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

"Warren" wrote:

Quote:

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
'Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0 F9136409AF1EF80F28D2F75CCB063'
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
/~Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F7980902B0FF2E492926AAAB562CD7FB0 F9136409AF1EF80F28D2F75CCB06364155A67FC3F53A636D8D 82F1BF0F310179B10952DB99756086EF1813A1F6FF6EA2C152 8117E6EFF2588B40915703ABA1953AC7FF001F348A88BDF043 A94CCB2C0CCD41C0A82D7E8E4D340040F825EA6EBA04D467B3 C4C24D6DFFBEB6E4AF0148E6FE2358

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

Thanks,

Warren

#3

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

Quote:

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
'Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F79
80902B0FF2E492926AAAB562CD7FB0F9136409AF1EF80F28D2 F75CCB063' 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
/~Z0xDACA57B0C1C78A9F5FAB370FD23FEFC72AF239EB4BCF82 0D2EE90034267F654F7
980902B0FF2E492926AAAB562CD7FB0F9136409AF1EF80F28D 2F75CCB06364155A67FC
3F53A636D8D82F1BF0F310179B10952DB99756086EF1813A1F 6FF6EA2C1528117E6EFF
2588B40915703ABA1953AC7FF001F348A88BDF043A94CCB2C0 CCD41C0A82D7E8E4D340
040F825EA6EBA04D467B3C4C24D6DFFBEB6E4AF0148E6FE235 8
So it looks like this the the internal SQL # to identify this job.
How can I make the job run? Any ideas appreciated.

Thanks,

Warren

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Package Fails With This Error: Line 1: Incorrect syntax near ' - 04-13-2006 , 07:01 AM

RE: DTS Package Fails With This Error: Line 1: Incorrect syntax near ' - 04-13-2006 , 09:08 AM

Re: DTS Package Fails With This Error: Line 1: Incorrect syntax near ' - 04-13-2006 , 09:05 PM