Sorted File Enumerator (SSIS)

• g1696412

  SSC Enthusiast

  Points: 144

  More actions

  August 18, 2015 at 5:24 am

  #299783

  Hello,

  I am looking for solution how to loop through sorted list of files and load them into database in that sorted order. I've found e.g. this http://microsoft-ssis.blogspot.cz/2011/04/how-to-configure-foreach-loop-container.html but unfortunately it does not working. The problem is with the Script Task. There is error with it, with this line of code:

  [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

  The AddIn here is underlined. So I tried to remove this line, but it is still not working.

  I am using Visual Studio 2014, 64-bit.

  Dont you know what could be wrong? Or are you aware of any other solution that fits MS VS 2014?

  Thank you.

  Regards,

  g

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  August 18, 2015 at 7:41 am

  #1820727

  Hello,

  You don't have to copy the snap-in line, only the code between

  public void Main()

  {

  ....

  Dts.TaskResult = (int)ScriptResults.Success;

  }

  Don't forget

  using System.IO; // Added

  at the beginning, so the code can use fileInfo