dbTalk Databases Forums  

SQL EM closes in DTS designer on Text File Destination

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


Discuss SQL EM closes in DTS designer on Text File Destination in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dave Harper
 
Posts: n/a

Default SQL EM closes in DTS designer on Text File Destination - 10-18-2004 , 05:38 PM






A clients SQL Server DTS designer is doing some strange
things. When a text file destination icon is added to
the designer window and the pump task is added to it,
things get strange.

When I go to define the columns of the text file nothing
shows in the column def area. If I try to click back
into the "Define" button EM hangs and closes...strange.

When this happens there is no error, exit code, and a
record isn't added into the Event Log.

Are my DLL files corrupt for designer? What else could
it be? Any help would be GREATLY appreciated!

Dave Harper
BI Consultant
Quilogy



Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: SQL EM closes in DTS designer on Text File Destination - 10-18-2004 , 07:39 PM






One possibility is they need to install the MS03-031 patch.
Check the following Knowledge base article:
FIX: DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/?id=814113

-Sue

On Mon, 18 Oct 2004 15:38:30 -0700, "Dave Harper"
<dharper (AT) quilogy (DOT) com> wrote:

Quote:
A clients SQL Server DTS designer is doing some strange
things. When a text file destination icon is added to
the designer window and the pump task is added to it,
things get strange.

When I go to define the columns of the text file nothing
shows in the column def area. If I try to click back
into the "Define" button EM hangs and closes...strange.

When this happens there is no error, exit code, and a
record isn't added into the Event Log.

Are my DLL files corrupt for designer? What else could
it be? Any help would be GREATLY appreciated!

Dave Harper
BI Consultant
Quilogy



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.