I'm using BIDS2008 and I want to add a file to the Miscellaneous folder of my SSIS project.
I have tried:
This must be something really simple, but I have no idea what.
Any help appreciated.
Thanks in advance.
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.
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.
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With