SSIS development project folder structure
Hi, I am new to SSIS and currently working on a tasks of creating SSIS packages. I have created 5-6 packages till date and created a separate project solution and configuration files for each of these package. Now i want to create a standard folder structure with single solution file so that whenever i create a new package, i will place the package in this project solution instead of creating a new one. Can any one tell me what should be a standard project folder structure for development??
July 8th, 2011 6:39am

Do you want to create a TEMPLATE for your SSIS packages? if yes, do this: after creating a package with any setting and configuration you want, copy it into this address: C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ ProjectItems\DataTransformationProject\DataTransformationItems\ now, whenever you want to create new package from this template , under menu,project, add new item you will find that template.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 6:51am

@Reza : Yes, i will be creating standard template for logging. But i need a standard project folder structure in the development enviorment something similar to 3-layer .net project.
July 8th, 2011 6:55am

I think you can create a template folder and just copy and paste that folder for every new project, look at this thread for more: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/5cbee33b-c4df-4c0b-85cf-32c33d109181http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 7:16am

Hi, Below is the new folder structure which i created ----------SSIS Project Folder ----Code Folder -------Solution File --------Package Folder ----Config Folder so all my created created would go in the 'Package Folder' and the config files for these individual packages would go in separate Config folder Let me know if this folder structure can be improved.
July 8th, 2011 8:41am

you can use SSIS Package Explorer from codeplex, to manage folders in SSIS as you want: http://ssispackageexplorer.codeplex.com/http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 8:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics