Post reply

Installing SSDT and creating your first SSIS Package

  • July 8, 2018 at 8:35 am

    #358194

    Comments posted to this topic are about the item Installing SSDT and creating your first SSIS Package

  • July 9, 2018 at 11:18 am

    #1996830

    Kumar Attangudi Perichiappan Perichappan - Sunday, July 8, 2018 8:35 AM

    Comments posted to this topic are about the item Installing SSDT and creating your first SSIS Package

    I realise that there is a lot to cover when creating an article such as this, and part of doing a good job is knowing what to leave in and what to exclude. Well done for giving this a go.

    But I would suggest that your Multicast / row number example is not a good one, because no one would ever design a package like that in the real world. We don't want newcomers learning bad practices from day 1.
    Instead, why not simply 
    1) Excel source to
    2) Rowcount to
    3) SQL Server destination
    ?
    In your example, the data does not 'go anywhere', and I can imagine this being puzzling to those new to SSIS.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 9, 2018 at 1:20 pm

    #1996853

    Just an FYI, the latest version of Visual Studio 2017 is 15.7.4.

    Thanks!

  • July 9, 2018 at 6:01 pm

    #1996885

    CatPhish - Monday, July 9, 2018 1:20 PM

    Just an FYI, the latest version of Visual Studio 2017 is 15.7.4.

    Thanks!

    To CatPhish's point, you should probably just say "the latest version at this time is _______", or just say "you can find the latest version in your Microsoft account downloads" and then let the users find the specific one themselves.

    However, it probably was the latest version when you wrote this up, so all good. Folks who want to design packages should be able to figure out how to get the latest version if they need to.

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

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

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