Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unable to define more than 22 columns

1 view
Skip to first unread message

Al Cadalzo

unread,
Feb 5, 2004, 1:53:03 PM2/5/04
to
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

unread,
Feb 5, 2004, 2:50:56 PM2/5/04
to
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

unread,
Feb 5, 2004, 3:48:21 PM2/5/04
to
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

unread,
Feb 5, 2004, 4:08:44 PM2/5/04
to
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...

0 new messages