Search This Blog

Tuesday, November 29, 2011

SQLISPackage100 Error - Invalid URI: The hostname could not be parsed

This error occurs on when the destination of the surface area is set to "dimension" in multi server environments when the advanced stage settings are not set correctly.

To solve, goto the feed Surface Area, click on the Advanced option in the Staging Environment section.  Set the SSIS package store to distributed = "Y".  The server name should be set to the BPC Application server name. 

This allows the feed to round robin correctly with the Application server.

No comments:

Post a Comment