Was going to create a config file for my solution. I was just wondering if the Miscellaneous folder would be good place. Wondering if any one has an opin ion or suggestion. Thanks, Mike

This is going to come with a huge "It Depends".... Is this config file only used by your current package or solution, or is this config file going to be used across multiple packages and projects / solutions? How do you generally deploy your packages? Your situation will dictate whether or not it is appropriate to save in the misc folder... Usually that is fine.

Computermike wrote: Was going to create a config file for my solution. I was just wondering if the Miscellaneous folder would be good place. Wondering if any one has an opin ion or suggestion. Thanks, Mike i'm not sure if i understand your question. an xml package configuration file is automatically added to the project's miscellaneous folder when it's created in BIDS. is there a reason why that wouldn't be a good place to store the configuration file?

Duane Douglas wrote: an xml package configuration file is automatically added to the project's miscellaneous folder when it's created in BIDS. I cannot, for the life of me, figure out how to add Solution Folders, as well as files to the Miscellaneous folder. Also, when I add an XML Package Configuration File, the Wizard has a file location, and does not add it to Miscellaneous folder as you are indicating.Am I missing something or does this have something to do with my Visual Studio Version ? (i.e. disabled features...). I am using Visual Studio 2005 Professional Edition - Version 8.0.50727.42 (RTM 50727.4200)

If it does not add it automatically you can right click on the Solution and say add existing item and select your config file. This should add the .dtsconfig to your Miscellaneous folder as this not a .ds or .dtsx file. HTH

That answers the Miscellaneous folder question. Thanks Mukti !

ShivaManjunath wrote: Duane Douglas wrote: an xml package configuration file is automatically added to the project's miscellaneous folder when it's created in BIDS. I cannot, for the life of me, figure out how to add Solution Folders, as well as files to the Miscellaneous folder. Also, when I add an XML Package Configuration File, the Wizard has a file location, and does not add it to Miscellaneous folder as you are indicating. your right. i misspoke...again. sorry about that. when an existing xml package configuration file is added to an ssis project (add > existing item), it is placed in the miscellaneous folder by default. hth

Ok, do you know how (or if at all) I can add my solution folders into an SSIS Project ?For example, under my project's BIDS folder, I would like to create a set of folders like soroot\Configurationsroot\CheckpointFiles........So is it possible to "include" these folders in the solution, like we can in regular VS2005 or VS2008 solutions ? That way, I can browse into the folder from with BIDS and see the files I want to see without leaving BIDS -Shivamycodetrip.com

There is now an utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS: http://ssisconfigeditor.codeplex.com/