Hi Anilbabu,

According to my experience, if you want to begin with SQL Server Integration Services, we should what we can do with SSIS, the architecture of Integration Services, SSIS features and tasks, and then how to design a package which can be deployed and executed. You can do some exercises by tutorials, when encountering the problems, you can post them to forum to get some help.

If you want to learn SQL Server Reporting Services, the method is similar to SSIS. You need to know SSRS components and how to design a report. We suggest you can refer to the following links and eBook to achieve your goal.

SSIS:

SQL Server Integration Services

Architecture of Integration Services

SQL Server Integration Services (SSIS) Part 1: Basics of SSIS and Creating Packages

SSIS Tutorial for beginners step by step video examples

SSRS:

Tools (SSRS): http://msdn.microsoft.com/en-us/library/ms155792.aspx Reporting Services Component Overview: http://technet.microsoft.com/en-us/library/aa256330(v=sql.80).aspx Planning and Architecture (Reporting Services): http://technet.microsoft.com/en-us/library/bb522679(v=sql.105).aspx Report Server : http://msdn.microsoft.com/en-us/library/ms157231.aspx Reporting Services Reports: http://msdn.microsoft.com/en-us/library/bb522712.aspx Report Data: http://msdn.microsoft.com/en-us/library/hh213736.aspx   Report Parameters: http://msdn.microsoft.com/en-us/library/dd220464.aspx   Report Parts:http://msdn.microsoft.com/en-us/library/ee635721.aspx Service Architecture(SSRS): http://msdn.microsoft.com/en-us/library/bb630409(v=sql.105).aspx

Down eBook: SQL Server 2012 Tutorials

If you have any other question, please feel free to ask.

Regards,
Shrek Li

If you have any feedback on our support, please click here. 

• Edited by Shrek LiMicrosoft contingent staff 3 hours 49 minutes ago