DTS bug with SP/3?

[kek1102]

I just put SP/3 on a SQL 2000 server. One of our Apps people has a DTS pkg with a BULK INSERT task. The task failed with a syntax error.

I started Profiler and ran the task (Thanks, Paul!). Here is the statement that fails:

BULK INSERT [TABS].[dbo].[StgSAPInterface] FROM '\\Sqltest\tabs\02262003TRE20143268TAPDR.txt' WITH (ORDER(RowNo )BATCHSIZE = 10000 , FIELDTERMINATOR = '\t' , ROWTERMINATOR = '\n' , MAXERRORS = 10 )

Notice there is no comma inserted after ORDER(RowNo ) so there is the syntax error.

I've browsed the Microsoft boards but haven't found any mention of this error. Has anyone else run into this problem?
-------------------
Someone suggested the error may be ocurring because I applied SP/3 via Terminal Server, that I should log into the server locally to applyu SP/3. Comments?

[rmiao]

Tried recreate package?

[kek2000]

Tried to recreate the pkg?

Yes. We saved the task in question to a separate pkg so it would be easier to run tests.

[kek2000]

From MSFT newsgroups board:

"This issue has been filed as bug #: 469069 (SQL Server 8.0)
Hopefully there will be a KB article and maybe a hotfix soon"

Thanks, all.