SSIS - Batch process with parallelism and with range mechanism

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  May 18, 2014 at 9:18 pm

  #291486

  [font="Verdana"]

  Hi All,

  I am working on one SSIS package where I am supposed to fetch / read millions of records and dump into a flat file. For this I am planning to implement batch-wise data selection in parallel. Can anyone suggest how to implement batch mechanism and make them run in parallel?

  Kindly let me know,

  Thanks in advance

  -- Mahesh

  [/font]

  MH-09-AM-8694

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 19, 2014 at 11:39 am

  #1714736

  Are you thinking you will have multiple flows writing to the same flat file in parallel? I don't think this is possible because I think the first task to start writing to the file takes an exclusive lock on it.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question