Skip to Content
0
Former Member
May 14, 2008 at 01:38 PM

eData - Import Excel

49 Views

I am trying to run an import from an Excel sheet and am getting the following error messages:

[Selection]

-


XLFILE=\HO\FINANCE\DataManager\DataFiles
SAPSAMPLE.xls

SHEET=SAPSAMPLE

COLUMNS=Account,CostCentre,Time,Product,Project,LoB,Version,Chanel,Entity,Measure

TRANSFORMATION=\HO\FINANCE\DataManager\TransformationFiles
T_FR01.xls

CLEARDATA= No

RUNLOGIC= Yes

CHECKLCK= Yes

[Messages]

-


Package Error Events:

ErrorCode = -1073450901

Source = ExcelToText

SubComponent= DTS.Pipeline

Description = "component "EXCELFILE" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

IDOfInterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

Package Error Events:

ErrorCode = -1073450996

Source = ExcelToText

SubComponent= DTS.Pipeline

Description = One or more component failed validation.

IDOfInterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

Package Error Events:

ErrorCode = -1073594105

Source = ExcelToText

SubComponent=

Description = There were errors during task validation.

IDOfInterfaceWithError= {8BDFE889-E9D8-4D23-9739-DA807BCDC2AC}

Package Error Events:

ErrorCode = -1073450901

Source = ExcelToText

SubComponent= DTS.Pipeline

Description = "component "EXCELFILE" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

IDOfInterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

Package Error Events:

ErrorCode = -1073450996

Source = ExcelToText

SubComponent= DTS.Pipeline

Description = One or more component failed validation.

IDOfInterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

Package Error Events:

ErrorCode = -1073594105

Source = ExcelToText

SubComponent=

Description = There were errors during task validation.

IDOfInterfaceWithError= {8BDFE889-E9D8-4D23-9739-DA807BCDC2AC}

Does anyone have any ideas ?

Thanks

Si