Skip to Content
0
Former Member
Apr 09, 2010 at 10:21 PM

Error Loading Rate data through Data Manger Pakage

32 Views

Hi all,

I wanted to load the Rate data so I uploaded my excel file on the server and it was successful. Even when I preview the data file it shows me first 200 records but when I run the Data Manger Pakage, I see the following error in the status.

TOTAL STEPS 2

1. Convert Data: Failed in 0 sec.

[Selection]

----


FILE=\STUDENT\RATE\DataManager\DataFiles\My Files\Rate.xls

TRANSFORMATION=\STUDENT\RATE\DATAMANAGER\TRANSFORMATIONFILES\SYSTEM FILES\IMPORT.XLS

CLEARDATA= No

RUNLOGIC= Yes

CHECKLCK= No

[Messages]

----


The data file is empty. Please check the data file and try again.

My Transformation file is as follows::

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER =

SKIP = 1

SKIPIF =

CREDITNEGATIVE=NO

CONVERTAMOUNTWDIM=

MAXREJECTCOUNT=

VALIDATERECORDS=YES

*MAPPING

*CONVERSION

Please help.

Diksha CHopra.

Edited by: Diksha Chopra on Apr 10, 2010 12:45 AM