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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 4:16 AM
Points: 485, Visits: 626
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: 2 days ago @ 11:42 AM
Points: 13,295, Visits: 11,086
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: 2 days ago @ 7:20 AM
Points: 5,180, Visits: 12,033
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.
Post #1501034
Posted Thursday, October 3, 2013 1:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:42 AM
Points: 13,295, Visits: 11,086
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: 2 days ago @ 11:42 AM
Points: 13,295, Visits: 11,086
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