Edit DTS package crashes MMC

#1

I used the export wizard to create a package to export a table to a CSV text
file. When the wizard is done the package runs OK and creates my CSV file.

However you can not edit the resulting package. When trying to edit the
Transform Data Task the “Verifying Transformations” dialog pops up. If you
then go to the Destination table none of the output columns are defined. Try
to use the Define Columns button and the entire management console/Enterprise
Manager crashes.

Using SQL Server 2000 SP3 / 8.00.760

#2

I note you ar eusing SP3

Are you seeing this

http://support.microsoft.com/default...en-us%3B814113

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Jim Brown" <jb (AT) applicationsplus (DOT) com.(donotspam)> wrote

Quote:

I used the export wizard to create a package to export a table to a CSV
text
file. When the wizard is done the package runs OK and creates my CSV file.

However you can not edit the resulting package. When trying to edit the
Transform Data Task the "Verifying Transformations" dialog pops up. If you
then go to the Destination table none of the output columns are defined.
Try
to use the Define Columns button and the entire management
console/Enterprise
Manager crashes.

Using SQL Server 2000 SP3 / 8.00.760

#3

It was similar, but I installed the hot fix anyway and it seems to have worked.

Thanks!

"Allan Mitchell" wrote:

Quote:

I note you ar eusing SP3

Are you seeing this

http://support.microsoft.com/default...en-us%3B814113

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Jim Brown" <jb (AT) applicationsplus (DOT) com.(donotspam)> wrote in message
news:E725AB56-9D01-4BA3-9B54-77753B8952C3 (AT) microsoft (DOT) com...
I used the export wizard to create a package to export a table to a CSV
text
file. When the wizard is done the package runs OK and creates my CSV file.

However you can not edit the resulting package. When trying to edit the
Transform Data Task the "Verifying Transformations" dialog pops up. If you
then go to the Destination table none of the output columns are defined.
Try
to use the Define Columns button and the entire management
console/Enterprise
Manager crashes.

Using SQL Server 2000 SP3 / 8.00.760

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

Edit DTS package crashes MMC

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

Edit DTS package crashes MMC - 01-27-2005 , 04:37 PM

Re: Edit DTS package crashes MMC - 01-28-2005 , 12:24 AM

Re: Edit DTS package crashes MMC - 01-28-2005 , 07:31 AM