"Unsure" <anonymous@discussions.microsoft.com> wrote in message
news:A6AA9976-DDA1-4CE1-8140-FEF817377FC7@microsoft.com...
> Where is the article located?
>
> ----- Allan Mitchell wrote: -----
>
> The article I posted presents some ideas
>
> --
>
> 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
>
>
> "Unsure" <anonymous@discussions.microsoft.com> wrote in message
> news:542EF6E7-DA80-45CB-A92B-082C8F238E04@microsoft.com...
> > The datasource is an excel spreadsheet. So it is Jet based.
> > Any ideas?
> >> ----- Allan Mitchell wrote: -----
> >> You have not told us anything about the source datasource.
> >> Is it Jet based?
> >> http://support.microsoft.com/?kbid=281517
> >> --
> > --
> >> 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
> >>> "Unsure" <anonymous@discussions.microsoft.com> wrote in
message
> > news:8B64E94F-4E56-49C3-8702-29AC7C222082@microsoft.com...
> >> I created a DTS package that produces this error when run:
> >>> "Data for source column 1 ('Text') is too large for the specified
> buffer
> > size."
> >>> When I looked at the column within the Transformations tab, it
has
> a
> > datatype of varChar(255). I believe that the problem is that
the
> data from
> > the source column is too large for varChar(255). Is there a
way to
> change
> > the size of this buffer for the source column so that the data
can be
> > transferred?
> >>> Thanks!
> >>>