Script Task C# Code(The name 'Dts' does not exist in the current context)

• zoom19

  Right there with Babe

  Points: 784

  More actions

  April 29, 2013 at 11:41 am

  #292763

  // C# code

  using System;

  using System.Data;

  using System.IO; // Added

  using Microsoft.SqlServer.Dts.Pipeline;

  using Microsoft.SqlServer.Dts.Runtime;

  //[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]

  public class ScriptMain : UserComponent

  {

  string SplitData = Dts.Variables["User::SplitData"].Value.ToString();

  public override void CreateNewOutputRows()

  {

  // Read file (use the FILE connection added in the script component, named myFile)

  using (StreamReader sr = new StreamReader(this.Connections.myFILE.ConnectionString, System.Text.Encoding.UTF7)) // Encoding is optional

  {

  String line;

  // Read lines from the file until the end of the file is reached.

  if ((line = sr.ReadLine()) != null)

  {

  if (line.Contains("Clock ID"))

  SplitData = "ClockID Data";

  else

  SplitData = "Employee Clock Data";

  }

  else

  throw new Exception("No data in the file");

  }

  }

  }

  I wrote above code in my script task and giving error when I am declare variable.

  can you please advice me.I don't know about c# code but I need to use my package to search particular word from .csv file .

  thanks in advance....

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  April 29, 2013 at 1:25 pm

  #1610980

  SSIS 2005 Script Tasks only support VB.net.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• jm99

  SSCommitted

  Points: 1740

  More actions

  May 1, 2013 at 4:13 pm

  #1611747

  Which are you intending to create:

  A ScriptTask on the Control Panel or,

  A ScriptComponent in a Dataflow?

  If a ScriptComponent then the Dts reference is not used to access variables. Specify the variable in the components read-only variable list on the property page then reference it ib C# using the this.Variables collection (similar to how you used this.Connections). The defined variables are returned as typed values eg.

  string str = Variables.MyStringSSISVariable;

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 1, 2013 at 4:19 pm

  #1611749

  As opc.three said earlier, you can use any .NET language you want in SSIS 2005 as long as it is VB.NET. C# support was added in SQL Server 2008.