It sounds like you’re debatching each individual line in the CSV file into an individual message that is being uploaded to SQL Server.
You need to modify your CSV flat-file schema so that only one message is generated from each input file (i.e. one flat-file with ten records creates one Xml message with ten records). Then, map that to your SQL schema and send over the WCF-SQL adapter – only one transaction will be used (although depending on how you have crafted your SQL schema, several INSERTS may be performed within the single transaction).
One other point, you don’t need to use an orchestration here (unless you need some of the functionality provided – NACKS, error handling etc.). You could just bind the WCF-SQL Adapter send port directly to the Receive Port and save the overhead of instanciating an orchestration.
Hope this helps, Nick.