Re: DTS Field Lenght

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 13:48:47 +0100

Are you then running into this

http://support.microsoft.com/?kbid=247527 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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
"Stan Sainte-Rose" <stan@cyber972.com> wrote in message
news:uImXBV9REHA.3012@tk2msftngp13.phx.gbl...
> Hi Allan,
> The source is a SQL datatable,
> The destination is a Txt File...
> The name of the attribute..
>
> By name of the attribute I mean, the FieldName..
>
> Stan
>
> -- 
>
>
> ---------------------------------------------------------------------
> "Are you still wasting your time with spam?...
> There is a solution!"
>
> Protected by GIANT Company's Spam Inspector
> The most powerful anti-spam software available.
> http://mail.spaminspector.com
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> a écrit dans le message de
news:
> #RitX$8REHA.3168@tk2msftngp13.phx.gbl...
> > What is the Source?
> > What is the destination type.
> >
> > Are you referring to the data within the attribute or the name of the
> > attribute.
> >
> >
> > -- 
> >
> > ----------------------------
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > 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
> >
> >
> > "Stan Sainte-Rose" <stan@cyber972.com> wrote in message
> > news:OGn5hE8REHA.3056@TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > I m working on a dts package, and it seems there is a limit with the
> field
> > > lengths..
> > > When I use several long field names like IdCompanyNameTemp, the dts
> > failed.
> > > I have to convert them into small name like IdCompanyNameTemp as
expr1,
> > > etc.....
> > >
> > > The limit seems to be 235 (when I add each caracters of the different
> > fields
> > > that I use)...
> > >
> > > Any idea ?
> > >
> > > Stan
> > >
> > >
> > >
> > >
> > >
> > > -- 
> > >
> > >
> > > ---------------------------------------------------------------------
> > > "Are you still wasting your time with spam?...
> > > There is a solution!"
> > >
> > > Protected by GIANT Company's Spam Inspector
> > > The most powerful anti-spam software available.
> > > http://mail.spaminspector.com
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages
Loading