Installing SSDT and creating your first SSIS Package

Question

Installing SSDT and creating your first SSIS Package

Kumar Attangudi Perichiappan Perichappan

SSC Rookie

Points: 36
More actions
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

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

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

CatPhish SSC Journeyman Points: 81 More actions · Answer 2

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

Thanks!

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 3

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