Script component fails after installing integration services

• Jeff Shurak

  SSCrazy

  Points: 2361

  More actions

  December 8, 2016 at 11:38 am

  #319614

  I put together a pretty simple script. It adds a row number column to a flat file. Very simple, very straight forward.

  [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]

  public class ScriptMain : UserComponent

  {

  private int m_rownumber;

  public override void PreExecute()

  {

  base.PreExecute();

  m_rownumber = 0;

  }

  public override void PostExecute()

  {

  base.PostExecute();

  }

  public override void Input0_ProcessInputRow(Input0Buffer Row)

  {

  m_rownumber++;

  Row.rownumber = m_rownumber;

  }

  }

  This ran fine in SSDT, however it bombed in SQL agent because IS was not installed. I installed IS and now the script fails due to 'Object reference not set to an instance of an object'. If I uninstall IS, it runs fine.

  This is all SQL Server 2012. Any ideas?

  Edit: It appears to be some mismatch going on on my local machine....with various versions of SQL installed. I rebuilt the package on a clean install and its running fine.