Monthly Archives: May 2009

Calculation tab not working – SQL Server 2005 Analysis Services

Problem/Bug: In Business Intelligence Development Studio for SQL Server 2005 analysis services, when we click on ‘Calculation’ Tab to define some calculated measures & all, we can get the following error: ‘Unexpected error occurred: ‘Error in application.’ Also having this … Continue reading

Posted in SQL Server, SSAS | 6 Comments

Digital Signing a SSIS package (SQL Server 2005 Integration Services – Security)

General theory about Digital Signing & data security: In SSIS we have some options to secure our package’s content by applying certain protection levels. These defined protection levels protects the package from being viewed by unwanted users. By using these … Continue reading

Posted in SQL Server, SSIS | 4 Comments

How to handle Nested Transactions in TSQL (SQL Server 2005)

In SQL Server 2000, we used to handle the errors while performing the DML queries by means of global variable @@Error. These errors may occur due to many reasons like data type mismatch, referential integrity violation etc. The @@error variable … Continue reading

Posted in SQL Server | 7 Comments

Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

As now a days, sharepoint has become very propular and is widely used. And people come acorss the requirements to make share point communicate with SQL server; to & fro. And there may be need to load data from share point … Continue reading

Posted in Others, SQL Server, SSIS | Leave a comment