The ability to transform corporate data into meaningful and actionable information is the single most important source of competitive advantage in today’s business world. Harnessing the data explosion to better understand the past and get direction for the future has turned out to be one of the most challenging ventures for enterprise Information Technology departments in global organizations. There are three broad categories of issues associated with data integration:
•Technology challenges•Organizational issues
•Economic challenges
In this paper, we will explore these challenges in detail and discuss how to address them with Microsoft® SQL Server™ 2005 Integration Services (SSIS). First, let’s view them in the context of a real-world scenario.
Microsoft sql server 2005 integration services is just like dts services in sql server 2000 but now it is called integration services with Microsoft sql server 2005
here is the link for more details.
http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx