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

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 (AT) cyber972 (DOT) com> wrote

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 (AT) no-spam (DOT) sqldts.com> a écrit dans le message de news:
#RitX$8REHA.3168 (AT) tk2msftngp13 (DOT) phx.gbl...

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 (AT) cyber972 (DOT) com> wrote

Hi Allan
I thank you for the link..

In fact, here's my query from my Dts package

----------------------------
SELECT CAST(idEtablissementTemp AS varchar) AS IdEtbTemp,
CAST(IdEtablissement
AS varchar) AS IdEtb, FkIdTypeEtb, CodeFiness, CAST(NoOrdre
AS varchar) AS Ordre, Nom, CAST(FkIdEtablissementTemp
AS varchar) AS FkIdEtbTemp, CAST(FkIdEtablissement AS varchar) AS
FkIdEtb, CAST(NoOrdreFils AS varchar)
AS OrdreFils, CAST(Nblits AS varchar) AS NbLits, CAST(Nbplaces AS
varchar) AS NbPlaces, Siteweb, FkIdTypeprojet1, FkIdTypeprojet2,
FkIdTypeprojet3,
VilleAnnuaire, CAST(FkIdDepartement
AS varchar) AS FkIdDep, Service, adresse, adresseComplement, BP,
CP, Cedex, Ville, FkIdPays, Tel, Fax, Email,

OnLine, CAST(ModifieLe AS varchar) AS ModifieLe
FROM
T_ETABLISSEMENTS_TMP_EXPORT
WHERE validetemp='O'
----------------------------


If I remove all the cast functions, SQL Server freezes when I try to define
the columns from the Data Task Properties.


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.comou


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> a écrit dans le message de news:
#t25Qb9REHA.628 (AT) TK2MSFTNGP11 (DOT) phx.gbl...