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