Is there any way to perform the CRUD operation on the SalesForce object and fields from SQL Server queries like SSIS, or anything?
The free jitterbit salesforce data loader does that.
You can hook up the source as a SQL database, pick a table, create your query, and then set your target as your salesforce object. And then you can have it run on a schedule.
I currently have it grabbing data from a oracle11g database and upserting to SF every minute. Shockingly awesome that it's free.
I have used Talend for such integration. It is free and there is Salesforce connector available out of the box. It is also great that you can export your integration job to a
.bat file and schedule it with some tool i.e. Windows Scheduler so that your integration will run at a specified time daily or whenever you need.