I set up a transform task between a sql service connection and a text file (destination). My sql server table has 48 columns and I want to export them all to a comma delimited text file. When I am at the 'Define Columns' dialog I see all 48 columns listed, but when I click the Execute button no columns are defined (no columns show in the grid of the dialog window). If I the click on 'Define Columns' I get an unrecoverable error ("Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience."). So I tried reducing the number of columns I was trying to export. I found that if I have 22 or less columns in my SELECT then I am OK, the columns are defined and the transform works OK. If I go over 22 columns then I get the error.

Thanks,
Al

This is a problem introduced in SP3

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/default...B;EN-US;814113

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

I set up a transform task between a sql service connection and a text file
(destination). My sql server table has 48 columns and I want to export them
all to a comma delimited text file. When I am at the 'Define Columns'
dialog I see all 48 columns listed, but when I click the Execute button no
columns are defined (no columns show in the grid of the dialog window). If
I the click on 'Define Columns' I get an unrecoverable error ("Microsoft
Management Console has encountered a problem and needs to close. We are
sorry for the inconvenience."). So I tried reducing the number of columns I
was trying to export. I found that if I have 22 or less columns in my
SELECT then I am OK, the columns are defined and the transform works OK. If
I go over 22 columns then I get the error.

Thanks,
Al

Allan,
Thanks so much. I'll apply that fix and see what happens.
Al


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Allan,

That fix did the trick. I can't thank you enough.

Al


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote