Post reply

Easy way to learn Scripting in SSIS?

  • April 9, 2008 at 5:13 am

    #124762

    Hi,

    As i am new to programming I want to learn how to write VB.net script for script component and script task.

    Is there any easy way to learn ?

  • April 9, 2008 at 1:58 pm

    #800611

    Let's give a lift to the topic, as i want to learn this too.

  • April 9, 2008 at 2:35 pm

    #800633

    Have you ever programmed before in any other language but SQL?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 9, 2008 at 2:38 pm

    #800635

    I did some in JAVA and little in .net, but that was long back in the college only.

  • April 9, 2008 at 2:46 pm

    #800640

    The reason I ask the question is all about basic programming concepts.

    If you've done programming before (non-SQL), then you probably know all about the basic concepts of structure and covering your IFs with your ELSEs, etc. Basically, how not to create the infamous "spaghetti code". This is important in all types of programming, but rarely (until the advent of Assemblies, etc in SQL 2k5) is seen in T-SQL programming because T-SQL just wasn't robust enough to do what was necessary.

    And if you know the basics, then picking up scripting isn't as difficult as it might seem. The first thing you might want to do is get one of those SAMS programming in 24 hours (or 24 days) books if there's one available or a Dummy's Guide book. These are the best way to pick up a new language, though they won't show you everything.

    And you'll probably want to get a black book or reference sheet and definitely want to link up to the Microsoft TechNet pages where all the commands are listed.

    However, if you have never programmed outside of T-SQL before, I highly recommend taking one of those community college classes on Introduction to Computer Programming.

    Learning a new language is one thing, and the more computer languages you know, the easier they are to pick up. However, if you don't know the basics behind programming, then it doesn't matter how fast you "learn" scripting, you're still going to miss something vital which might kill your package.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 9, 2008 at 10:20 pm

    #800754

    Hi,

    Even I have done some JAVA programming before so this suggesion might help. But if you know any links that provides good tutorials that will be great! Thanks for replying

  • April 10, 2008 at 9:02 am

    #801031

    The code project has a whole lot of scripting help

    http://www.codeproject.com/

    I refer to W3 Schools continually. It has a LOT of scripting help.

    http://www.w3schools.com/

Viewing 7 posts - 1 through 6 (of 6 total)

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