SSIS Script - Can't open connection

• elkucho

  SSC-Addicted

  Points: 457

  More actions

  November 3, 2011 at 11:27 am

  #262316

  Hello!

  I've faced another issue. When trying to use a script and a managed connection, I'm getting an error :

  System.NullReferenceException: Object reference not set to an instance of an object.

  Here's the code I'm using :

  public override void Input0_ProcessInputRow(Input0Buffer Row)

  {

  try

  {

  string xSQL = "";

  SqlConnection sqlConn = new SqlConnection();

  sqlConn = (SqlConnection)(Connections.cnnProLog.AcquireConnection(null) as SqlConnection);

  SqlCommand sqlComm = new SqlCommand();

  sqlConn.Open(); // < --- Code is failing here

  .

  .

  .

  Not sure what I'm missing.

  Thanks in advance

• elkucho

  SSC-Addicted

  Points: 457

  More actions

  November 3, 2011 at 1:01 pm

  #1402885

  Nevermind, really sorry. The problem was not on the code!

• Kobus-291740

  Newbie

  Points: 7

  More actions

  February 7, 2012 at 11:20 pm

  #1444292

  Hi.

  Please tell me where the problem was because I have got the same issue.

  Thanks