Analysis Cubes on SQL 2008

Wednesday, May 20, 2009 2:54 PMalaadin_75

0
Sign In to Vote
Dears,

When Run the Integration Services packages for populating the data warehouse database and processing the cubes, the job fails and the following error:

Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:41:10 PM Error: 2009-05-20 17:41:14.64 Code: 0xC02020F4 Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22] Description: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for it. End Error Error: 2009-05-20 17:41:14.64 Code: 0xC02020F4 Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22] Description: The column "CMPNYNAM" cannot be processed because more than one code page (1252 and 1256) are specified for it. End Error Error: 2009-05-20 17:41:14.64 Code: 0xC004706B Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline Description: "component "OLE DB Destination" (22)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2009-05-20 17:41:14.64 Code: 0xC004700C Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2009-05-20 17:41:14.64 Code: 0xC0024107 Source: Copy Data from Results to CompanyMaster Task Description: There were errors during task validation. End Error Error: 2009-05-20 17:41:14.65 Code: 0xC00220E4 Source: Run Company Description: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run. . End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:41:10 PM Finished: 5:41:14 PM Elapsed: 3.907 seconds. The package execution failed. The step failed.

I'm using Arabic 1256 CI, AS, any advise on how to populate the data.

Thanks