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