I have a Order.txt file which Contains the Header and 10,000 Records as Body and also Trailer Part. I have Three tables in my SQL Server. Header_Data, Body_Data and Trailer_Data. Now My Requirement is First i need to insert the header in Header_Data and i need to pick the Primary Key and insert that body (each record ) with primaryKey (Here in Body_Data the primary key will become Foreign key) record by record and same case for Trailer too. I used updategram it was working fine 100 records with bulk insertion but i need to loop through the 10,000 records and insert in to database.
is there any way to do this using loop shape and SQL adapter stored Procedures?
Please help me