ssisvisual-studio-2017sql-server-data-toolsvisual-studio-community

Use a SSIS package as Template in SSDT for Visual Studio 2017 Community

. Hi everybody!, I'm running into a small problem.

I have VS 2017 Community Edition, I've installed SSDT (SQL Server Data Tools) I've built an SSIS package (a generic one) and now I would like to use it as a template for future packages.

So, I was digging in the web, also here in StackOverflow and found for example this article:

Setting up SSIS Item Template in SQL Server Data Tools for Visual Studio 2012

I found lot of other articles in MS for example:

https://learn.microsoft.com/en-us/sql/integration-services/create-packages-in-sql-server-data-tools

others, etc. and followed up to the tee but, for some reason I can't make it work.

This is my folder structure for my VS installation

The VS Folder struture image

I've left out of the tree some folders that doesn't apply to the problem

I put my package in the places I found in the articles and didnt work.

Sometimes, in the articles mentioned folders that I didn't have so I created and tried but nothing also (so deleted this folders)

I'm really lost, I tried everything I read, and some "creative things" from my yard but no results.

Anyone has come through this or has some experience about this issue? Anyone can help?

Thank you very much. Best regards and Happy new year!! Gabriel

Solution

  • Well based on the articles I've read and the help of @billinkc, I finally figured out where to put the package, I was missing something also, but I realised when I read @billinkc answer.

    When you are on VS Community Version, you have to put the package in this path:

    C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\SSIS\ProjectItems\DataTransformationProject\DataTransformationItems

    The files you need to make it work are, a dtsx file (the package that will be the template) and a vsdir file which mainly needs to have this structure I used this values and worked fine:

    YourPackageName.dtsx| |The name you want to appear|100|The description of the package| |21| |#44

    You can check all the fields of the vsdir file in the MS documentation:

    https://learn.microsoft.com/en-us/visualstudio/extensibility/internals/template-directory-description-dot-vsdir-files

    So now I have it running! Thanks for your help!!