cancel
Showing results for 
Search instead for 
Did you mean: 

Import SQL into Fact Table - Conversion Error

Former Member
0 Kudos

Hi All,

I am new to BPC MS and did not know much into MS SQL.

I am facing the Conversion error while converting between unicode and non unicode string data types.

We are using SAP BPC 10.0 MS SP13, EPM-Addin SP18 on .Net 4

The below is the error log

Total Step: 4

SQLToTxt: Failed in 0 seconds

Import SQL into Fact Table: Failed in 0 seconds

[Selection]

--------------------------------------------------------------

DB = BPC

TABLE = GlBalanceOpening

COLUMNS = Account,Auxiliary,Curr,BalanceDateTime,Amount

TRANSFORMATION = \JMG\LIQ_JMG\DataManager\TransformationFiles\GLOpeningBalances.xls

CLEARDATA = No

RUNLOGIC = No

PROCESSCUBE = Yes

CHECKLCK = No

[Message]

--------------------------------------------------------------

An error occurred while executing a package.

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "Account" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "AccountName" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "Auxiliary" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "AuxiliaryName" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "Curr" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "Dr" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1071636234

Source = SQLToTxt

SubComponent= OLE DB Source [68]

Description = Column "Cr" cannot convert between unicode and non-unicode string data types.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1073450901

Source = SQLToTxt

SubComponent= SSIS.Pipeline

Description = "component "OLE DB Source" (68)" failed validation and returned validation status "VS_ISBROKEN".

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1073450996

Source = SQLToTxt

SubComponent= SSIS.Pipeline

Description = One or more component failed validation.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events: 

ErrorCode = -1073594105

Source = SQLToTxt

SubComponent=

Description = There were errors during task validation.

IDOfInterfaceWithError= {B4E78907-3D9C-4229-9DB9-6A311E45C779}

Thanks and Regards,

Raj

Accepted Solutions (1)

Accepted Solutions (1)

former_member186498
Active Contributor
0 Kudos

Hi Raj,

you have to modify the script of your package, see please 1629737 - Error in ImportSQL Data Manager Package

Regards

     Roberto

Former Member
0 Kudos

Thanks Roberto, Package ran successful.

Regards,

Raj.

Answers (0)