January 14, 2008

WIS 00504 error on Business Objects XI

If you get a WIS 00504 error message when trying to perform an action that requires access to a Universe (e.g. new WebI or DeskI report), this probably means that you don't have enough security privileges to acess the Universe's data. You need to have "View on Demand" rights over the Universe and "View on Demand" rights over the corresponding Universe Connection.

January 2, 2008

SSIS Script Component throws "Object reference not set to an instance of an object"

In Integration Services 2005, if you get an Object reference not set to an instance of an object exception when trying to manipulate rows from a Script Component, even after you have guaranteed that the column is set as an input for the script, try checking if the column you're accessing is not null, using the automatically available "_IsNull" property. For example, if the input column is called myInputCol, you can try something like this:
If Not Row.myInputCol_IsNull Then
'code that access the column here
End If