Can you please answer below questions. please add your answer inline
Q1) In a Flat File there are millions of records. It consists of many
rejections data. Now if rejections are
a) from 0% to %25 of rejections, then continue process
b) from 25% to 40% of rejections, then Trigger a email
c) from 40% to 50% of rejections, then wait for user to respond
d) > 50% of rejections, then Abort the sequence
Q2) Suppose I want to execute a sql task before that i want to do some
job, how you will do?
Q3) Revenue Report has daily transactions of million and billions of
revenue records of different category as MMS Revenue, Internet Calling
Revenue etc. Want report of revenue received from 1 to 30 days. How to
do?
Q4) In one single flat file the data of customers are given in multiple
record. for e.g. first record has cust name, cust date
second record has cust address, cust phone
third record has cust email, cust status
How you will create one record destination from three records?
Q4) I would take this flat file, import the data into a database table, then use a stored procedure to get all of the appropriate data columns (cust name, cust date, etc.) into the proper format.
Then use a data flow task to execute a stored procedure to return the data in the proper format and use this to populate a flat file (or whichever type of destination task you would like to use to contain this data).
I hope this helps!