Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS scripting - Visual Basic or Visual C sharp - Why ? Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 12:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
I want to learn one language so that I can do script tasks easily. Which one should I learn - visual basic or visual c# ?

Which is better if -

1 - you know java well

2 - want to develop code quickly

3 - easy for beginners

4 - has most functionality for ETL developers
Post #1501014
Posted Thursday, October 3, 2013 1:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:57 PM
Points: 517, Visits: 646
it totally depends on your choice,,,, and this is totally personal to choose between them,,

i prefer to choose C#, because,
my teammates are working on c#, so i get help from them, and learning guidance.


Post #1501016
Posted Thursday, October 3, 2013 1:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
If you know Java well, C# is the obvious choice.
You can do the same things in a script task/components with C# or Visual Basic, so it all boils down to personal choice.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501017
Posted Thursday, October 3, 2013 1:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:44 PM
Points: 5,317, Visits: 12,352
1 - you know java well
C#

2 - want to develop code quickly
C# is less verbose

3 - easy for beginners
VB.NET has the edge here, IMO

4 - has most functionality for ETL developers
both equal



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1501034
Posted Thursday, October 3, 2013 1:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
Phil Parkin (10/3/2013)

3 - easy for beginners
VB.NET has the edge here, IMO


I learned both languages by self-study, and they are both easy in my opinion.
Looking at the future and other applications of those programming languages, I wouldn't waste my time with VB, but start with C#.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501035
Posted Thursday, October 3, 2013 1:34 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116

Looking at the future and other applications of those programming languages, I wouldn't waste my time with VB, but start with C#.


I don't understand what do you mean by "future and other applications". Can you give me some examples ? Were you suggesting that VB has no future or is a dying language ?
Post #1501332
Posted Thursday, October 3, 2013 1:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
etl.laptop (10/3/2013)

Looking at the future and other applications of those programming languages, I wouldn't waste my time with VB, but start with C#.


I don't understand what do you mean by "future and other applications". Can you give me some examples ? Were you suggesting that VB has no future or is a dying language ?


I'm noticing in my environment that C# is more dominant.
Some may argue VB is a bit dying, but I think it might stay around for a while.
I won't be using it though.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse