Re: DTS crash with 36 column SELECT Query
From: Bill (anonymous_at_discussions.microsoft.com)
Date: 07/27/04
- Next message: Norm Bowler: "Re: Syntax example for DTS task.execute"
- Previous message: DHatheway: "Re: DTS Environment Control"
- In reply to: Allan Mitchell: "Re: DTS crash with 36 column SELECT Query"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 08:46:57 -0700
Thanks, just after I posted this I found my information
from before and got the problem fixed.
Bug #: 363997 (SHILOH_BUGS)
>-----Original Message-----
>You are right this is an SP3 issue and there is a fix
>
>814113 - FIX DTS Designer May Generate an Access
Violation After You
>Install SQL Server 2000 SP3
>http://support.microsoft.com/default.aspx?scid=KB;EN-
US;814113
>
>--
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.SQLDTS.com - The site for all your DTS needs.
>www.konesans.com - Consultancy from the people who know
>
>
>"Bill" <anonymous@discussions.microsoft.com> wrote in
message
>news:4fc901c473ec$e9e43620$a401280a@phx.gbl...
>> I am running SQL Server 2000 SP3 and have a DTS package
>> that uses a SELECT query to dump data to a | (pipe)
>> delimted file. The SELECT statement has 36 columns in
>> it. Whenever I try to edit the trasformations mmc.exe
>> crashes and I get blown out of Enterprise manager. I
>> remeber having this problem about a year and half ago on
>> another server that had SP3 on it. There was some sort
of
>> Hot Fix or patch that we applied and it fixed the
>> problem. Back then I remeber finding a MS Knowlege Base
>> article saying that it was aknown bug when there were
more
>> than 22 columns or something like that.
>>
>> Can anyone help...I'm pretty sure this isssue has a
patch.
>>
>> Thanks,
>> Bill
>
>
>.
>
- Next message: Norm Bowler: "Re: Syntax example for DTS task.execute"
- Previous message: DHatheway: "Re: DTS Environment Control"
- In reply to: Allan Mitchell: "Re: DTS crash with 36 column SELECT Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
