Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to Add a File to the SSIS Project Miscellaneous Folder

Tags:

ssis

bids

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.

like image 852
JM Hicks Avatar asked Jan 07 '13 09:01

JM Hicks


People also ask

How do I add a SSIS to Solution Explorer?

From the Solution Explorer, right click on SSIS packages and then choose the Add Existing Package option. In the window, browse for your packages. You need to load them one by one. They all will appear under SSIS Packages in the Solution Explorer.

How do I open SSIS packages in Visual Studio?

In Visual Studio, click New > Project on the File menu. In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services. Select Integration Services Import Project Wizard from the project types list.

What is build solution in SSIS?

Hello, Indeed a "Build" in SSIS Projects is a bit similar to a C# Projects. During designing a package you have the current . DSTX file in your project folder. After a build (or rebuild) you have the same file in subfolder \bin to, but that one don't change until you build the package again.

What is SSIS package?

A SQL Server Integration Services (SSIS) package includes the necessary components, such as the connection manager, tasks, control flow, data flow, parameters, event handlers, and variables, to execute a specific ETL task. For an introduction to key SSIS functionality, check out the SSIS Basics guide.


1 Answers

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

like image 116
praveen Avatar answered Nov 16 '22 14:11

praveen