How do you organize files in SSIS project ?

Question

I am trying to migrate from older SSIS shell to 2019 visual studio .
I would like to know how do you all organize the dtsx by task? I dont see a way to create folders inside my SSIS project .
Do you all make projects inside the solution for each of the main task and place the parent/relevant chile ssis in the same folder?

Answer 1

You should keep all related packages in the same project. The key question is what should be deployed together. If you need to deploy the parent and child packages together then there is no reason to separate them out into separate projects.

I would argue that if you need folders to organize all your packages then maybe your packages are too complex and intermingled. SSIS projects do not support virtual folders which is what would be needed here. Having said that though you could probably move your package files into subfolders in the file system and then add them using the "Existing Item" option to the project. It wouldn't change the layout in Solution Explorer though.

Answer 2

Hi @Srividhya Sundaram ，

You may export each SSIS Project to .ispac file and Import into Visual Studio.

Make sure that each project contains the parent and child packages.

Check extract-import-and-migrate-ssis-project.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.