"Allan Mitchell" wrote:

> Hello Matt,
>
> LTRIM() and RTRIM() are also string functions in the deived column transformation.
> Looking again at the data you hold in the column this is a better fit as
> using REPLACE() would cause
>
> "John Doe "
>
> to become
>
> "JohnDoe"
>
>
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
> > Hi Allan,
> > I'll give it a try. I didn't know if RTRIM could be used in the
> > package or
> > not and if so, where I would put it. This is my first SSIS package so
> > it was
> > a bit different than the few DTS I have done in the past.
> > Thanks!
> >
> > "Allan Mitchell" wrote:
> >
> >> Hello Matt,
> >>
> >> I would use a Derived Column transform. something like
> >>
> >> REPLACE([Column Name]," ", "")
> >>
> >> --
> >>
> >> Allan Mitchell
> >> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
> >> |
> >> http://www.konesans.com
> >>> I'm using SSIS to bring fixed width files into the database. After
> >>> the package runs the data has blank spaces at the end of it that
> >>> need to be trimmed so "John Doe " would become "John Doe". What
> >>> is the best way to trim the blanks when using a SSIS package to do
> >>> the insert?
> >>>
> >>> Thanks,
> >>> Matt
>
>