How to generate SSRS Report and How to deploy in MOSS

Hi,
Here you can learn how to deploy/integrate a SSRS report with MOSS application.

Assumptions:
Report Server has been configured for SharePoint Integration Mode.
SharePoint Report Server Integration Feature is activated.
Appropriate Content Types (Report Builder, Report Builder Report, Report Data Source) have been added to a Document Library within a site.

For further information on these configuration topics, see Deploying SSRS with SharePoint Integration.

Assume the following server/site/library/folder names:
• Server Name = MyServer
• SP Site = SiteABCReports
• Doc Library = SSRS Reports
• Data Sources Folder (optional) = Data Sources
• Report Models Folder (optional) = Models
• Reports Folder (optional) = Reports

Deploy Report Designer Reports

From within a SQL Server Business Intelligence Studio (BIDS) Report Server Project, go to the project’s Property Page (right-click project in Solution Explorer and select Properties).
Apply the following deployment settings:
• Overwrite ExistingDataSources = True
• TargetDataSourceFolder = http://MyServer/SSRS%20Reports/[Data%20Sources]
• TargetReportFolder = http://MyServer/SSRS%20Reports/[Reports]
• TargetServerURL =http://MyServer

Where [‘xxx’] denotes optional.

Things to note:

• A TargetReportFolder must be specified. The folder can be the document library or a folder within the document library.
• The TargetDataSourceFolder is optional. If one is not specified, the Data Source will be deployed to the TargetReportFolder.
• For both target properties, if the folder within the document library does not already exist, it will be created upon deployment.
• Relative paths are not valid.
• The replacement of the space character with %20


See the below article for step-by-step approach to deploy the report on MOSS.
http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html

Here you can download some of the sample SSRS reports,it’s really nice work.
http://blogs.msdn.com/b/chrisfie/archive/2008/04/10/new-sql-reporting-services-sample-reports-for-project-server.aspx

Linked server in sql server 2008

Hi,
When you are setting up a linked server, register the connection information and data source information with SQL Server. After registered, that data source can be referred to with a single logical name.
You can use stored procedures and catalog views to manage linked server definitions:
• Create a linked server definition by running sp_addlinkedserver.
• View information about the linked servers defined in a specific instance of SQL Server by running a query against the sys.servers system catalog views.
• Delete a linked server definition by running sp_dropserver. You can also use this stored procedure to remove a remote server.
You can also define linked servers by using SQL Server Management Studio. In the Object Explorer, right-click Server Objects, select New, and select Linked Server. You can delete a linked server definition by right-clicking the linked server name and selecting Delete.
When you execute a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query. This four-part name should be in the form linked_server_name.catalog.schema.object_name. For more information, see Distributed Queries.

Step-by-step procedure available in below article.
!! Thanks madhu !!
http://madhuottapalam.blogspot.com/2008/08/configuring-linked-server-from-sql.html

SSIS Migration from 2000 (dts) to 2008 (dtsx)

Integration Services provides the DTS Package Migration Wizard for migrating SQL Server 2000 Data Transformation Services (DTS) packages that were created by using the DTS tools and object model.
Not all packages can be migrated completely. For example, some DTS tasks do not map to Integration Services tasks, custom tasks cannot be migrated, and some scripts in ActiveX Script tasks or in data transformations cannot be migrated. For more information, see Migrating Tasks and Known DTS Package Migration Issues.
Packages left in the DTS package format can be used in Integration Services solutions and can also continue to run as stand-alone DTS packages.
Many DTS packages are password-protected. If you migrate these packages, the Package Migration Wizard prompts you for their passwords. You cannot migrate a password-protected package unless you provide the correct password.
SQL Server does not install support for Meta Data Services. The Package Migration Wizard supports Meta Data Services (Repository) packages only if SQL Server 2000, the SQL Server 2000 tools, or the Repository redistributable files are installed on the local computer. When the Repository files are present, the Package Migration Wizard can migrate DTS packages that were saved to Meta Data Services. When the Repository files are not present, the Package Migration Wizard can only migrate DTS packages that were saved to SQL Server or to structured storage files.
You can find some known issues in migration here

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/
http://technet.microsoft.com/en-us/library/ms143462.aspx

I have some nice links which describes step by step how to migrate DTS to SSIS 2008.
I hope that will help u goto following urls:

http://www.infosys.com/microsoft/resource-center/DTS-SSIS-2008-migration.pdf

http://weblogs.sqlteam.com/derekc/archive/2008/02/19/60518.aspx

http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps.html


Downloads:
http://pragmaticworks.com/DTSxChange-vs-MSWizard.pdf

Video link for "how to migrate SQL Server 2000 DTS packages to SQL Server 2008"

http://www.msdev.com/Directory/Description.aspx?eventId=493

INDIA won the world cup 2011

!! Hearty Congrats Team !!

Geospatial Data with Sql Server 2008 R2

Overview
Microsoft SQL Server 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications which ultimately helps end users make better decisions.
Top New Features
• Use the new geography data type to store geodetic spatial data and perform operations on it
• Use the new geometry data type to store planar spatial data and perform operations on it
• Take advantage of new spatial indexes for high performance queries
• Use the new spatial results tab to quickly and easily view spatial query results directly from within Management Studio
• Extend spatial data capabilities by building or integrating location-enabled applications through support for spatial standards and specifications

Visual analysis of location data
Geographical Factors in Decision-Making and Analysis
The spatial support in Microsoft SQL Server 2008 can help you make better decisions through visual analysis of location data.
Make better decisions
Visual analysis of location data in scenarios such as:
• Consumer-focused location-based information
• Customer-base management and development
• Environmental-related data impact, analysis, and planning
• Financial and economic analysis in communities
• Government-based planning and development analysis
• Market segmentation and analysis
• Scientific research study design and analysis
• Real-estate development and analysis

Geodetic Model


Planar Model
Comprehensive Spatial Support
Build spatial capabilities into your applications by using the support for spatial data in SQL Server 2008.
Work with geodetic data
• Implement Round Earth solutions with the geography data type. Use latitude and longitude coordinates to define areas on the Earth’s surface
• Associate geographical data with industry standard ellipsoids, such as WGS84, which is used in GPS-enabled solutions worldwide
Work with planar data
• Implement Flat Earth solutions with the geometry data type.
• Store polygons, points, and lines that are associated with projected planar surfaces and naturally planar data, such as interior spaces
Build on industry standards
• Import and export spatial data in industry-standard formats, such as Well Known Text, Well Known Binary, and Geographic Markup Language (GML)
• Take advantage of geometry data type compatibility with Open Geospatial Consortium (OGC) standards for geometric data types
Perform spatial operations
• Use the methods provided by SQL Server 2008 spatial data types to write Transact-SQL code that performs operations on spatial data, such as finding intersections between geospatial objects and distances between locations

Spatial Results Tab
High Performance Spatial Data Capabilities
Achieve high performance spatial capabilities with SQL Server 2008
Store large and complex spatial objects
• Use the spatial types in SQL Server 2008 to accommodate spatial objects, regardless of whether the objects are simple or very complex
Build high-performance solutions with spatial data indexing
• Enhance query performance by using indexes for spatial data that are integrated into the SQL Server database engine
• Take advantage of accurate query optimizer cost assessment for spatial queries that can determine the optimal query plan and identify appropriate index selection
View results directly from within Management Studio
• Use the new spatial results tab to easily view spatial query results directly from within SQL Server Management Studio
• Simple projection and zoom/pan capabilities for quick investigation
Consolidate relational and spatial data in business applications
• Use the native support for spatial data types in SQL Server 2008 to seamlessly incorporate spatial data into line-of-business applications
• Avoid the performance and manageability issues associated with a dedicated spatial data store

Virtual Earth SDK
Geospatial Application Extensibility
Extend spatial support by integrating spatial data in SQL Server 2008 with location-enabled applications and services.
Build spatial solutions of any scale
• Take advantage of spatial support in multiple editions of SQL Server 2008, from SQL Server Express to SQL Server Enterprise Edition
Use spatial standards support to integrate applications
• Leverage a .NET-based geometry library that supports OGC standards. Build applications that consume and manipulate spatial data
• Integrate with geospatial services, such as Microsoft Virtual Earth, to build comprehensive location-enabled solutions that render your spatial data for display
Benefit from spatial community support
• Take advantage of spatial products and services offered by Microsoft partners that integrate with SQL Server 2008
• Microsoft partners with the leading GIS application providers and a range of spatial community organizations, integrators, and ISVs that support SQL Server 2008

I copied from the below site.
http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx

For Installing SQL Server 2008 R2 on Windows Server 2008 R2, See the below link:
http://www.mytechmantra.com/LearnSQLServer/Install_SQL_Server_2008_R2_P1.html

Visualizing the SPatial Data:
http://msdn.microsoft.com/en-us/magazine/ee335706.aspx
Download 'SPatialData' detail document and sample script from here.
http://download.microsoft.com/download/a/c/d/acd8e043-d69b-4f09-bc9e-4168b65aaa71/SpatialData.doc
Watch the video:
http://blogs.msdn.com/b/nikosan/archive/2010/11/06/data-connector-web-cast-dec-2nd-2010.aspx

Regards,
Ravindra

URGENT REQUIREMENT IN A MNC FOR MSBI RESOURCE(SSIS/SSAS/SSRS)-***only in USA***

Hi Guys,
If you are in MSBI plaform(SSIS or SSAS or SSRS), send me your profile on my emailID.
It is really good opportunity who looking to change.
!! All The Best !!
============================================
eMailID:-->nv.ravindranathreddy@gmail.com
============================================
Regards,
Ravindra

SSAS-Dynamic Cube Partition Refresh

Hi,

Here you can see Refresh the Cube Partition dynamically using SSIS Package.

The steps are involved,
 Drop the existing Partitions on the cube
 Re-Create the Partitions.
Get more details about Cube-Partitions.
http://msdn.microsoft.com/en-us/library/ms175604.aspx
Here is the link to implement Partition at cube level.
http://sql-bi-dev.blogspot.com/2010/12/dynamic-cube-partitioning-in-ssas-2008.html
Download the sampl SSIS-Package here.
http://www.ziddu.com/download/14205603/Cube_Partition.zip.html

Regards,
Ravindra