Wednesday, October 28, 2015

SSDT: What is the Solution Items Folder?

There's a folder in a SQL Server Data Tools (SSDT) Solution Explorer called Solution Items*. It's a folder and its icon has a dotted outline -- so the implication seems to be that it's some kind of ghost folder, almost to say that it isn't quite like the others. I don't know how long it's been there, but today was the first day I noticed it**.

"What's that?" I wondered to myself. I searched and searched long and hard hours, in the rain, in the snow, and near mountains****. Naturally, the first article that popped up was an MSDN article: Solution Items. There weren't very many articles about it, which means it was a good candidate for this blog****.

In a lot of cases, there are files that a developer might want to draw attention to a file and add it to a Solution that doesn't necessarily fit into the actual code, for instance README files or installation instructions. They are not source files, they are not project files, they are just ... miscellaneous files! But they are still important.

In cases like the one below (an SSIS template), such files can be added (or drag-and-dropped!) into the Solution Items folder, as depicted below.

* For those who don't know, SSDT is just a shell of Visual Studio. Ergo, this information also applies to the full product. 
** Which is weird because I spend 30 hours a week in SSDT. 
*** It's not hard. I live in Denver and it was raining that day. 
**** I try to only post about things that don't already have a good presence in the Internet Mindshare.


  1. We understand our clients, and we know that they need only elite Low Rate Call Girls in Chanakyapuri.
    If you have desires and fantasises that never came true, then you are in for a treat. Hiring an Call Girls in Goa will give you the chance to enjoy a lot.
    Our super hot Call Girls in Goa are meant for providing best pleasures.
    Just call us on the given numbers and we bet that you are going to enjoy with Agra Russian Call Girls.
    There are lots of Agra Russian Call Girls available for you. We have lots of variety to offer too.
    You can get Ajmer Russian Call Girls, Bengali, Bihari, Punjabi, Latin, Russian, and lots more. Variety is key to us because clients prefer changes in their life.

  2. I really enjoy the article. Will read on...
    upload file

  3. Really appreciate you sharing this blog post. Thanks Again. Fantastic. best portfolio folder