Can SSIS run C/C++ Script?

Question

Post reply

Can SSIS run C/C++ Script?

water490

SSC Eights!

Points: 955
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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

kaj SSCommitted Points: 1605 More actions · Answer 1

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: 246960 More actions · Answer 2

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

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

water490 SSC Eights! Points: 955 More actions · Answer 3

water490

SSC Eights!

Points: 955

February 14, 2024 at 1:31 am

#4378248

thanks everyone!

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

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)