how can we do the data cleansing and Data filtering from the SQL 2005 server database to Maximo database
Set up connection to SQL 2005 database (simple and easy) see connection mangers in SSIS, and Extract the data. Once processed the data in way you want, lots of tools/processes for that in SSIS, Transforming the data. Then set up connection to Maximo, which l have seen a posting doing using MS Access DB so using possibly an OLEDB conneciton will allow out write the data to the tables in Maximo, Load the data.
SSIS is an ETL (Extract, Transform, Load) tool.
How you do these steps depends on the databases, business rules, data etc you are working with. Start playing with SSIS, then google and ask questions