"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:Od4CL7gAIHA.4200@TK2MSFTNGP04.phx.gbl...
>I am not a SSIS expert and that is why I suggested the sites. I do see now
>that you included among many other sites the DTS newsgroup but it doesn't
>look like the SSIS one. I suggest you post there (leaving out all the other
>ones that are not relevant) for more detailed answers.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Shane Jones" <doctorjones_md@yahoo.com> wrote in message
> news:%23diOlcfAIHA.4160@TK2MSFTNGP06.phx.gbl...
>> Andrew -- if (for example) a particular table has numerous fields that
>> require a RTRIM, how would I write this SQL statement. Would you point
>> me in the right direction with a quick example or reference?
>>
>> Thanks again.
>>
>> Shane
>>
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> news:O%23LRAYfAIHA.5416@TK2MSFTNGP05.phx.gbl...
>>> You can use a SQL statement to import the data that has a RTRIM() in it
>>> for that column or you can use a custom conversion in the ETL package.
>>> Is this DTS or SSIS?
>>>
>>> www.sqldts.com
>>> www.sqlis.ocm
>>>
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>> Solid Quality Mentors
>>>
>>>
>>> "Shane Jones" <doctorjones_md@yahoo.com> wrote in message
>>> news:uWVlwSeAIHA.5184@TK2MSFTNGP02.phx.gbl...
>>>> I've inherited a project which has numerous fields that have extra
>>>> spaces in them -- this is causing a problem with data Inserts, Edits,
>>>> and Deletions in my .ASP Website.
>>>>
>>>> I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I
>>>> need to know if there's a way that I can Right Trim all fields on the
>>>> imported tables during the Import Process.
>>>>
>>>> Will I have to scrub all these tables in ACCESS before hand, or is
>>>> there a much simplier method to trim the spaces during import.
>>>>
>>>> Thanks in advance for any ideas offered.
>>>>
>>>> Shane
>>>>
>>>
>>
>>
>