Chapter 9: Page 63. How to write the code in C# ?

niladri · May 28th, 2012, 10:48 PM

I use only C#. The example in page 63, is in VB. How do I write the code in C# ?

P.S. if Dts.Variables("intVar").Value > 10 --- shows error.

apratsunrthd · January 26th, 2014, 10:05 AM

When you first add your script task, set the ScriptLanguage to C#. SSIS won't let you change it once you've set it and clicked OK, so if it doesn't let you change it, delete that task and re-add it, setting it to C# from the start.

NatalyaS · August 17th, 2014, 06:44 PM

Quote:

Originally Posted by niladri

I use only C#. The example in page 63, is in VB. How do I write the code in C# ?

P.S. if Dts.Variables("intVar").Value > 10 --- shows error.

You need change the default settings so you would be able to enter the VB code. You can find the details in Ch.9. That's what I did.