Import SQL error

[former_member252174]

SAP EPM 10.0 SP 22 patch 2

SQL 2008 R2

Windows server 2008 R2 Enterprise 64bit

Help!,

I have setup this import SQl package, I have made the necessary changes for server,DB,table etc etc but I am still getting an error when running the package. the visual studio screen shots show the where its failing but I am not sure how to resolve.

Any ideas anyone?

Rgds

Terence

<RESULT><MESSAGE><![CDATA[An error occurred while executing a package.

Package Error Events: 

ErrorCode = -1073450901

Source = SQLToTxt

SubComponent= SSIS.Pipeline

Description = "component "SQL" (68)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

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}

]]></MESSAGE>

<PROMPT><![CDATA[

DB = STS_DATA

TABLE = STS_3

COLUMNS = ShopID,DT,DIONECODE,COMPANYID,VALUEFIELD,DESC1,DESC2

TRANSFORMATION = \RETAIL_SHOPS\SHOP_DATA\DataManager\TransformationFiles\stsdata.xls

CLEARDATA = Yes

RUNLOGIC = No

CHECKLCK = No

]]></PROMPT>

<STATUS_STEP><![CDATA[Total Step:@3

SQLToTxt:@ Failed in 1 seconds

Import SQL:@ Failed in 1 seconds

]]></STATUS_STEP>

</RESULT>

[former_member208963]

I can see that the BPC CUSTOM BPC tasks are not properly recognized/registered.

Are you doing these tasks on the server machine?, if not, you need to install OSoft SSIS Client.

Regards