Problem: DTS created prior SP3 installation

• andreask

  Mr or Mrs. 500

  Points: 542

  More actions

  April 27, 2004 at 4:05 am

  #59257

  Dear all,

  I am experiencing the following problem:

  I have created a DTS that reads data from a table (SQL Query) and creates a text file ( "|" delimited).  This DTS was created before installing SP3 on my server.  After installing SP3, the source table was modified (2 new fields were added) and therefore I am trying to refresh the Column Definition of my destination file.  Unfortunately, the current column definition is not shown and once I click on the "Define Columns" button, Enterprise Manager is terminated.

  I have been told that this is a bug on MS SQL Server and that there is a fix available.  Any ideas?

  Thanks & Regards,

  Andreas

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 27, 2004 at 9:24 am

  #504353

  Check this KnowledgeBase article and see if it applies to you:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;814113&Product=sql2k

  It includes a patch. 

  Greg

   

  Greg