Unable to define more than 22 columns

[Al Cadalzo]

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 Mitchell]

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.aspx?scid=KB;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" <cad...@hotmail.com> wrote in message
news:OrIQKlB7...@TK2MSFTNGP09.phx.gbl...

[Al Cadalzo]

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

"Allan Mitchell" <al...@no-spam.sqldts.com> wrote in message
news:O$tf1DC7D...@TK2MSFTNGP10.phx.gbl...

[Al Cadalzo]

Allan,

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

Al

"Allan Mitchell" <al...@no-spam.sqldts.com> wrote in message
news:O$tf1DC7D...@TK2MSFTNGP10.phx.gbl...