Dynamics AX Mobile 1.5 SSIS Package Failure when using SQL Server collation Danish_Norwegian_CI_AS

Recently we received some feedback around the SQL Server with Danish and Norvegian collation and we will like to communicate this work around to solve the problem. Error Description:  When running the Dynamics Mobile SSIS Package in SQL Server 2005/2008 the package may fail with messages similar to:                 Package Execution Utility:  “Error: SSIS Error…