SSIS in Visual Studio File and Folder Structure

• cpiacente

  Old Hand

  Points: 336

  More actions

  March 28, 2024 at 3:46 pm

  #4403879

  Hello,

  I had an oddball question I was hoping someone could point me in the right direction. In Visual Studio, when a project gets created and worked on, etc., a folder and file structure appears on your machine (obviously I know). What I am looking for is definitions of the file types, folder uses, etc. i.e. there is a folder in the solution called .vs, what is its purpose? what files are contained in there? Same with BIN and OBJ. What is a .database file or .dtproj/.dtproj.user? Things like that. Does such a site exist? I have been googling but not finding much help.

  Our ultimately goal is to learn what all these are to find out what we can potentially exclude in our gitignore file for deploying code to Azure Devops and such. Many of which we know like .dtsx is obviously the package and .conmgr is the connection manager. It would just be nice to see a Microsoft site or something that we can reference.

  Does anyone have any ideas?

  Thank you in advance!

  Chris

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  March 28, 2024 at 4:33 pm

  #4403904

  These are the only things we keep.

  • .sln - paths to the projects (.dtproj)
  • .dtproj - contains a listing of all the objects in your project
  • .dtsx - ssis packages
  • .conmgr - project level connection managers
  • .params - project level params
  • Also package parts if you use them
  • .git - source control

  bin will have the ispac files that you can use for deployment.

  obj is just a copy of the project objects and a build log.

  Our git ignore excludes bin, obj, user configs (.suo), .vs, .vspscc, .vssscc

  HTH