Can SSIS run C/C++ Script?

• water490

  Ten Centuries

  Points: 1076

  More actions

  February 13, 2024 at 6:26 pm

  #4378065

  hi everyone

  I need a particular calculation done that is really hard to do in SS so I am using another program for it.  The other program allows the code to be exported to C/C++ format.  I know that SSIS can run C# code.  Can it also run C/C++ code?

  thank you

• kaj

  SSCommitted

  Points: 1616

  More actions

  February 13, 2024 at 6:34 pm

  #4378092

  No, only VB.NET and C#.NET is supported.

  https://learn.microsoft.com/en-us/sql/integration-services/control-flow/script-task?view=sql-server-ver16

  Options

  ScriptLanguage

  Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  Follow

  February 13, 2024 at 6:39 pm

  #4378094

  SSIS can run compiled code through the use of an Execute Process task.

  ---

• water490

  Ten Centuries

  Points: 1076

  More actions

  February 14, 2024 at 1:31 am

  #4378248

  thanks everyone!

• Jeff Moden

  SSC Guru

  Points: 1004593

  More actions

  Follow

  February 14, 2024 at 2:11 am

  #4378269

  water490 wrote:

  I need a particular calculation done that is really hard to do in SS...

  I've heard such a thing many times.  The answer is always "No" unless you ask...

  What is the calculation, please?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)