How to Add a File to the SSIS Project Miscellaneous Folder

ssis bids
JM Hicks picture JM Hicks · Jan 7, 2013 · Viewed 7.7k times · Source

I'm using BIDS2008 and I want to add a file to the Miscellaneous folder of my SSIS project.

I have tried:

  1. to drag-and-drop a file to the folder icon in Solution Explorer - not allowed
  2. to right-click the folder icon - return 0 menu options
  3. to add-item from the project icon in Solution Explorer - didn't see anything helpful there
  4. to create the folder by hand, add a dummy text file, close-reopen-rebuild solution - no success of any kind

This must be something really simple, but I have no idea what.

Any help appreciated.

Thanks in advance.

Answer

praveen picture praveen · Jan 7, 2013

Right click on the Project Click ADD->Exisiting Item. Now you can point to any files in the dialogue box which does not have extension such as dtsx or config .Selecting these files will automatically place them in Miscellaneous folder

Related questions

Using SSIS BIDS with Visual Studio 2012 / 2013

I want to use SSIS /BIDS project in Visual Studio 2012. I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2012. VS 2010 was installed first followed by MS SQL 2012 which got me BIDS integrated with VS 2010. However …

Read More
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a …

Read More
How to access ssis package variables inside script component

How can I access variables inside my C# code which I've used in Data Flow -> Script Component - > My c# Script with my SSIS package? I have tried with which is also not working IDTSVariables100 varCollection = null; …

Read More