New Blogs For This Month

SSIS -Blogs
http://ganeshprof.blogspot.com/
http://rameshsql.blogspot.com/
Complete-Sql Server
http://bisqlserver.blogspot.com/
BizTalk Web Resources-
http://blogs.msdn.com/gsnowman/archive/2006/01/15/513159.aspx
.NET Banana-
http://blogs.msdn.com/gsnowman/

CRYSTAL-REPORTS-INFO

Crystal Reports software enables you to easily design interactive reports and connect them to virtually any data source. Your users can benefit from on-report sorting and filtering – giving them the power to execute decisions instantly.
And with Crystal Reports Visual Advantage, you can gain even more functionality for compelling reports. This bundled product includes Crystal Reports and Xcelsius Engage, giving you the power to create highly formatted reports with what-if scenario models, interactive charts – and deliver them via the Web, e-mail, Microsoft Office, Adobe PDF, or embedded in enterprise applications. As a result, you can leverage your reports to make better operational and strategic decisions.
With Crystal Reports, you can:
· Leverage professional reporting - priced for everyone
· Empower end users to explore reports with on-report sorting and parameters
· Minimize IT and developer effort with interactive reports
· Develop powerful data mashups
· Save valuable report design time
· Embed professional-looking reports in Java and .NET applications
· Tailor your solution by adding report management and viewing tools

http://www.crystalreportsbook.com/CrystalReportsXI.asp

SSIS- DTS to SSIS Migration

When you upgrade an existing SQL Server instance, DTS runtime remains in place. Your DTS packages are not affected and local server packages remain stored in the msdb.dbo.sysdtspackages table. Structured storage files, or packages saved to DTS files, are also unchanged.If you use Meta Data Services, previously called the Repository in SQL Server 7.0, you may encounter some problems. Meta Data Services is not supported by SSIS, which is not surprising considering that SQL Server 2000 Service Pack 3 removed Meta Data Services as a storage location. This is not a significant change, however, since the existing DTS object model and the DTSRUN command-line tool continue to support Meta Data Services.The most important thing to remember about the DTS-to-SSIS upgrade is that after it is complete, your packages will continue to run. Scheduled jobs will still use DTSRUN and call the same packages from the same locations as they did prior to the upgrade.When making the upgrade, you will need to determine how you will manage these legacy DTS packages in the future. The DTS runtime will continue to be available, and will have been updated to enable DTS packages to connect SQL Server 2005 data sources. But the DTS designer components are removed along with SQL Server 2000 Enterprise Manager.
See for more info:

http://bisqlserver.blogspot.com/2006/11/migrating-your-sql-2000-dts-packages.html
http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/

SSIS- Executing SSIS packages From a folder

Hi ,
to execute a SSIS package using from a folder,
We have the following three methods.
1. By using SSIS iDE,we can create a package to execute another package- SSIS control package
2. By using Sql Query Statement-Stored procedure
3. By using the command Prompt-DOS batch file
Here the link which gives cleared information for the same.
http://www.simple-talk.com/sql/sql-server-2005/executing-ssis-packages-/

SSRS-Advanced Matrix Reporting Techniques

Hi,
By using SSRS tool we can develop different reports as per the client requirements.
Even customer also easily understood reports without having any business idea by attending the graphical representation.
Q. I have the following SQL that I want to display in a report with totalsgrouped by year, quarter, month and week.select case statecode when '0' then 'Qualified' when '1' then 'Open'when '2' then 'Disqualified' end as 'Status',datepart(year, createddate) as 'year', datepart(quarter, createddate) as'quarter', datename(month, createddate) as 'month', DATEPART(week, createddate) - DATEPART(week, DATEADD(month,DATEDIFF(month, 0, createddate), 0)) +1 as 'week',count(*) as 'enqtotal'from bo_maingroup by datepart(year, createddate), datepart(quarter, createddate),datename(month, createddate), DATEPART(week, createddate) - DATEPART(week, DATEADD(month,DATEDIFF(month, 0, createddate), 0)) +1, statecodeorder by datepart(year, createddate), datepart(quarter, createddate),datename(month, createddate), DATEPART(week, createddate) - DATEPART(week, DATEADD(month,DATEDIFF(month, 0, createddate), 0)) +1, statecodeI have added a matrix to my report, and then added column groups foryear (=Fields!year.Value), quarter (=Fields!quarter.Value), month(=Fields!month.Value) and week (=Fields!week.Value). Then I have a rowunder these columns showing =Fields!Status.Value to the left and=Fields!enqtotal.Value underneath the column groups. I now need to add a row with the total of each enqtotal for eachyear/quarter/month/week combination. But upon right clicking my=Fields!enqtotal.Value cell, there is no option to add a subtotal.This is my first report matrix, so could somebody tell me what I amdoing wrong? If you need further explanation than please let me know.
A. See the below link for more information.
http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/