Run Business Rule for Import Set

[Hm10]

I have imported data set from excel through import set and transform map.

Now I want to validate the excel data through Business rule before it goes into transform map. 

It means that i dont to want to allow the data to be entered into transform map if it has 50 records for any same id. It has to immediately prompt the user in work notes that enter a correct file. and stop the transform map creation. unless user enters correct file.  this is what I was trying first in transform map script but now i want it to run in Business Rule Script.

[Tony Chatfield1]

Hi, if you are validating an import\transform then onStart transform script would probably be the most appropriate place to run your script. Perhaps you can clarify why you believe that a business rule is necessary and where\how you would run the BR on sys_import_set or sys_data_source tables?

[Hm10]

Hi @Tony Chatfield1 , thanks for your reply.

I have tried OnStart Transform Script, But it inserts the records until it finds 50 ids for a specific record. I dont want this insertion to take place at all in transform map, rather i want to not allow any insertion if there are atleast 50 ids of same record. 

[Tony Chatfield1]

Hi,  'The onStart event script is processed at the start of an import run, before any data rows are read.'

Perhaps the issue that your script does not run as expected\does not abort the transform if your condition of x matched records is met
Does your script set
ignore = true;

Map with transformation event scripts (servicenow.com)