Menu
I have Visual Studio 2012 solution with multiple BI projects. One of the SSIS projects do not show all the ssis packages in the Solution Explorer (checked in by another teammember). But the missing files are in the TFS (Source Control Explorer) and are visible in the physical folder.
I tried "Show all files" did not work. I tried adding the file again but the project does not allow that saying "file with same name exists".
Any idea what is going on here
707
If you can't see the toolbox, go to VIEW -> Other Windows -> SSIS Toolbox.
In SQL Server Data Tools (SSDT), open the Integration Services project in which you want to create a package. In Solution Explorer, right-click the SSIS Packages folder, and then click New SSIS Package. Optionally, add control flow, data flow tasks, and event handlers to the package.
Open SQL Server Data Tools (SSDT). On the File menu, point to New, and then click Project. In the New Project dialog box, select Business Intelligence, and then select the Integration Services Project template.
The authoritative source of what's in a project is going to be the ProjectName.dtproj file.
Inside of that will be entries for the packages that comprise the project. For a non-package deployment model, it's trivial to edit the file by hand and make your stuff show up.
It's way too much effort to do that by hand for a 2012+ project deployment model. Open the Project in Visual Studio (ssdt/bids) and right click on the project. Click Add Existing Item (not add package) and then click the "missing" package. Check your .dtproj file in and all is right with the world.
72
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
