Installing SSDT and creating your first SSIS Package

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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

    Thanks!

  • 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