all groups > sql server dts > july 2004 >
You're in the

sql server dts

group:

DTS crash with 36 column SELECT Query


DTS crash with 36 column SELECT Query Bill
7/27/2004 8:18:04 AM
sql server dts:
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,
Re: DTS crash with 36 column SELECT Query Bill
7/27/2004 8:46:57 AM
Thanks, just after I posted this I found my information
from before and got the problem fixed.

Bug #: 363997 (SHILOH_BUGS)



[quoted text, click to view]
Re: DTS crash with 36 column SELECT Query Allan Mitchell
7/27/2004 4:23:35 PM
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


[quoted text, click to view]

AddThis Social Bookmark Button