Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Integration Services

Status
Not open for further replies.
Oct 10, 2003
2,323
US
News from PASS--Microsoft Enhances Reporting Services; Renames DTS

At the 2004 Professional Association for SQL Server (PASS) Community Summit in Orlando, FL, last week Microsoft Corp. demonstrated new business intelligence capabilities for Microsoft SQL Server 2000 and SQL Server 2005. "We made a series of announcements on two main topics," Alex Payne, senior product manager for SQL Server, told 5 Minute Briefing, "the momentum for Reporting Services and SQL Server 2005."

According to Payne, more than 100,000 people have downloaded Reporting Services, which can be embedded in a variety of Microsoft applications to generate enterprise reports. At PASS, Microsoft announced new SQL Server Report Packs for Microsoft Exchange Server and Microsoft Business Solutions CRM. The Report Packs, available for free via download, will provide customers with templates of commonly used SQL Server Reporting Services reports that users can easily modify for their own reporting needs. In SQL Server 2005, Payne added, Reporting Services will support the generation of ad hoc reports utilizing technology Microsoft acquired when it purchase ActiveView earlier this year.

Microsoft also announced that its ETL tool, formerly know as Data Transformation Services (DTS), will be renamed Integration Services in SQL Server 2005. The service has been improved and at least one large company beta testing the product achieved a performance increase of 40 percent, Payne said. "A lot of people are getting excited," he added. According to Payne, SQL Server 2005 is currently in beta 2 testing. There is one more beta stage and the product should be released in the first half of next year. For more information, go to


-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top