HI, i am looking for options on getting sales force data into our dev(SQL SERVER 2008 R2) server, i found many third party tools but i am wondering if there is any way i can achieve it using SSIS, can some one please guide me with this, thanks in advance for the help!

Perhaps then you will need a SSIS custom connector to wrap the connectivity to Salesforce.

They expose WebServiecs and this page https://help.salesforce.com/HTViewHelpDoc?id=integrate_what_is_api.htm outlines which to use under what circumstances.

Salesforce SSIS Integration

Check the commercial COZYROC SSIS+ library. The library includes Salesforce adapters, which are extensively used in production. These are the first Salesforce adapters for SSIS introduced on the market back in 2009.

That's hellza cool, Murali.  I didn't know there was such a thing.  I would suggest creating some VBA code, in Excel, and download the data, then send it (from Excel) to SQL Server.  I'd think you can record a Macro to do most of the download stuff, then run another VBA script to pass it all from Excel to SQL Server.  Here's a link with several code samples that move the data from Excel to SS.

http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction