Month: September 2011
What are SSRS, SSIS and SSAS
Let me give a brief introduction of SSRS, SSIS and SSAS as
you can get more details on these topic if you google it.
Microsoft SQL Server Reporting
Services (SSRS) delivers enterprise, Web-enabled reporting functionality so you
can create reports that draw content from a variety of data sources, publish
reports in various formats, and centrally manage security and subscriptions.
Microsoft
SQL Server Reporting Services enables organizations to transform valuable
enterprise data into shared information for insightful, timely decisions at a lower
total cost of ownership.
SQL Server Reporting Services is a comprehensive, server-based solution that
enables the creation, management, and delivery of both traditional,
paper-oriented reports and interactive, Web-based reports. An integrated part
of the Microsoft Business Intelligence framework, Reporting Services combines
the data management capabilities of SQL Server and Microsoft Windows Server
with familiar and powerful Microsoft Office System applications to deliver
real-time information to support daily operations and drive decisions.
Services
It is a Data Warehousing Tool; SSIS
is one of the key features introduced in SQL Server and is the new DTS (Data
Transaction Services) platform. Microsoft
Integration Services is a platform for building enterprise-level data
integration and data transformations solutions. You use Integration Services to
solve complex business problems by copying or downloading files, sending e-mail
messages in response to events, updating data warehouses, cleaning and mining
data, and managing SQL Server objects and data. The packages can work alone or
in concert with other packages to address complex business needs. Integration
Services can extract and transform data from a wide variety of sources such as
XML data files, flat files, and relational data sources, and then load the data
into one or more destinations.
rich set of built-in tasks and transformations; tools for constructing packages;
and the Integration Services service for running and managing packages. You can
use the graphical Integration Services tools to create solutions without
writing a single line of code; or you can program the extensive Integration
Services object model to create packages programmatically and code custom tasks
and other package objects.
Microsoft SQL Server 2005 Analysis
Services (SSAS) delivers online analytical processing (OLAP) and data mining
functionality for business intelligence applications. Analysis Services supports
OLAP by letting you design, create, and manage multidimensional structures that
contain data aggregated from other data sources, such as relational databases.
For data mining applications, Analysis Services lets you design, create, and
visualize data mining models that are constructed from other data sources by
using a wide variety of industry-standard data mining algorithms.
—————————————————————-
— Assign All Items to a all Vendors
— Code by Venugopal G A
— mail me for any queries venuasg@gmail.com / venuasg@yahoo.com
—————————————————————-
DECLARE @VENDORID VARCHAR(30)
DECLARE @ITEM VARCHAR(100)
DECLARE @ITEMDESC VARCHAR(100)
DECLARE VENDOR CURSOR FOR
SELECT VENDORID FROM PM00200
OPEN VENDOR
FETCH NEXT FROM VENDOR INTO @VENDORID
WHILE (@@fetch_status <> -1)
BEGIN
DECLARE ITEMMASTER CURSOR FOR
SELECT ITEMNMBR, ITEMDESC FROM IV00101
OPEN ITEMMASTER
FETCH NEXT FROM ITEMMASTER INTO @ITEM, @ITEMDESC
WHILE (@@fetch_status <> -1)
BEGIN
INSERT INTO [IV00103] ([ITEMNMBR],[VENDORID],[ITMVNDTY],[VNDITNUM],[VNDITDSC])
VALUES(@ITEM,@VENDORID,1,@ITEM,@ITEMDESC)
FETCH NEXT FROM ITEMMASTER INTO @ITEM, @ITEMDESC
END
DEALLOCATE ITEMMASTER
FETCH NEXT FROM VENDOR INTO @VENDORID
END
DEALLOCATE VENDOR
Dynamics Tips 