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 error visual studio IDE will crash & will be closed automatically. This issue may not [...]

Read Full Post »

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 options we can save sensitive information like username, password etc in our package without letting [...]

Read Full Post »

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 tells us whether the last statement (immediate before the @@error variable is used) caused any [...]

Read Full Post »

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 applications to some database and vice versa; without much of extra coding efforts. In other [...]

Read Full Post »