Load and count only those Flat files which filename contain %vendor%.

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  August 25, 2015 at 9:22 pm

  #307213

  Hi ,

  I want to load and count only those Flat files which filename contain %vendor%.

  like

  abc_vendorpic.csv

  Hist_vendor_20150825.csv

  public void Main()

  {

  string TheSource = Dts.Variables["$Package::VendorItem_FilePath"].Value.ToString();

  string[] files = Directory.GetFiles(TheSource, "VENDOR*.csv", System.IO.SearchOption.TopDirectoryOnly);

  Dts.Variables["User::V_Filecount"].Value= files.Length;

  }

  and same file should load in for each loop container.

  what to change in above code .

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  August 26, 2015 at 2:09 am

  #1822402

  Hi

  Hmm, won't be easier if you simply set *vendor*.csv in Enumerator configuration section

  for Foreach File Enumerator?

  Bet regards

  Mike