Thank you so much, so can I disabled the guest account on system databases?

Yea I was surprised as well. I am not near my system, but if you can create one table and try the script on SQL Server 2008 to just check...

Did you use this update command on SQL Server 2008/ and R2?

UPDATE [state]

SET [state] = RTRIM([state])

I already used this update command but did not work. its emptying out the column.

UPDATE [state]

SET [state] = RTRIM([state])

create table state

(

state_Code int null,

state varchar(50) not null

primary key (state

);

Sorry I clicked on post accidently-

State_code State

1 Virginia

2...

Table name is state and columns are state_code and State

state_code State

1

Thank you so much for the reply I will try to use the script. Can you also please send me the update script to update the state column to remove...

Can you please suggest?

In advance editor for oledb source the output 'psource' data type is string [DT_STR] 500 length, I have the derived column set as

Psource_code= SUBSTRING(PSOURCE,3,FINDSTRING(PSOURCE,")",1) - 2)

Psource_Desc= ...

Thanks a lot! It did work!

Yes, You are my life saver... I will try and let you know. Than ks

Thank you so much for reply, but I need to use the substring in SSIS package. If you can provide me the command or transformation option to seperate the different...

Thank you very much! I did find the SP3 RTM and installed successfully.

Thank you so much Suresh. Since RTM is not ready for sp3 yet, do I need to install sp1 prior to install sp2?