Hi,

I am trying to create a text file in DTS using a transform
data task. The source data is a sql table. I found that
when the total header column width of the source table is
greater than 235 characters enterprise manager locks up
when trying to map the data columns.

I am using SQL 2000 Sp3a. I do not experience this
problem on SQL 7.


Here is an example of a table which is 235 characters wide
which works with no problems.

-- total of column width 235 works no problem
CREATE TABLE [dbo].[TestTable] (



[a1234567] [varchar] (1000) NULL ,
[b1234567] [varchar] (4) NULL ,
[d1234567] [varchar] (5) NULL ,
[e1234567] [varchar] (4) NULL ,
[f1234567] [varchar] (20) NULL ,
[g1234567] [varchar] (120) NULL ,
[h1234567] [varchar] (4) NULL ,
[i1234567] [varchar] (200) NULL ,
[j1234567] [varchar] (50) NULL ,
[k1234567] [varchar] (10) NULL ,
[l1234567] [varchar] (20) NULL ,
[m1234567] [varchar] (10) NULL ,
[n1234567] [varchar] (250) NULL ,
[o1234567] [varchar] (6) NULL ,
[p1234567] [varchar] (20) NULL ,
[q1234567] [varchar] (5) NULL ,
[r1234567] [varchar] (40) NULL ,
[S1234567] [varchar] (200) NULL ,
[T1234567] [varchar] (40) NULL ,
[U1234567] [int] NULL ,
[V1234567] [varchar] (20) NULL ,
[X1234567] [int] NULL ,
[Y1234567] [int] NULL ,
[Z1234567] [int] NULL ,
[Z1123457] [int] NULL ,
[Z2123457] [int] NULL ,
[Z3123457] [int] NULL ,
[Z4123457] [varchar] (1000) NULL ,
[Z41234] [varchar] (1000) NULL ,
[Z4123] [varchar] (1000) NULL


) ON [PRIMARY]
GO

Below, I made the last column one character longer so the
total is 236 and enterprise manager freezes when trying to
map the columns.

-- total of column width 236 locks up
CREATE TABLE [dbo].[TestTable] (
[a1234567] [varchar] (1000) NULL ,
[b1234567] [varchar] (4) NULL ,
[d1234567] [varchar] (5) NULL ,
[e1234567] [varchar] (4) NULL ,
[f1234567] [varchar] (20) NULL ,
[g1234567] [varchar] (120) NULL ,
[h1234567] [varchar] (4) NULL ,
[i1234567] [varchar] (200) NULL ,
[j1234567] [varchar] (50) NULL ,
[k1234567] [varchar] (10) NULL ,
[l1234567] [varchar] (20) NULL ,
[m1234567] [varchar] (10) NULL ,
[n1234567] [varchar] (250) NULL ,
[o1234567] [varchar] (6) NULL ,
[p1234567] [varchar] (20) NULL ,
[q1234567] [varchar] (5) NULL ,
[r1234567] [varchar] (40) NULL ,
[S1234567] [varchar] (200) NULL ,
[T1234567] [varchar] (40) NULL ,
[U1234567] [int] NULL ,
[V1234567] [varchar] (20) NULL ,
[X1234567] [int] NULL ,
[Y1234567] [int] NULL ,
[Z1234567] [int] NULL ,
[Z1123457] [int] NULL ,
[Z2123457] [int] NULL ,
[Z3123457] [int] NULL ,
[Z4123457] [varchar] (1000) NULL ,
[Z41234] [varchar] (1000) NULL ,
[Z41236] [varchar] (1000) NULL


) ON [PRIMARY]
GO

Has anyone else experienced this same problem?
Thanks.
Joe

Hi Dan

I don't know if this will help or not, but in my experience the Enterprise Mangler has difficulty displaying individual fields in the range of what you are having difficulties with. I thought the limit was 256 chars, but maybe that is adjusted with a varchar data field. One thing to try is to have the SQL Query Analyser return the rowset as text using Query-->Results in Text option

Hope that helps
John Miceli

Thanks for the idea. However, I am not have a display
issue. The problem is with setting up the data
transformations from the table to the text file in DTS.


displaying individual fields in the range of what you are
having difficulties with. I thought the limit was 256
chars, but maybe that is adjusted with a varchar data
field. One thing to try is to have the SQL Query Analyser
return the rowset as text using Query-->Results in Text
option.