I try to add an existed package to a SSIS project using Visual Studio. But it turns out the tool copies the package to a new package and name it as original name plus an incremented number first and then attach the package to the project. I know I miss some settings. But I could not find out what prevents the original package from attached. Anyone encountered the same problem. Thanks!
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 Solution Explorer, double-click the package. In SSIS Designer, click the Control Flow, Data Flow, or Event Handler tab. In the Connection Managers area, right-click the connection manager, and then click Copy.
Editing the SSIS package. 1 Open SQL Server Management Studio, and select the Server on which the SSIS package you want to edit is stored. 2 Expand the Data Transformation Services folder, so that you can see the SSIS packages. 3 Double-click the SSIS package you want to edit.
To copy variables we have to go to the SSIS Package code and then copy the required variable code and paste in Package2 xml file.
What is happening here is most likely that you have copied a package manually into the project directory and then tried to add it to the existing project. BIDS (Visual Studio) assumes you are copying from a different location, takes the name and copies the project into your directory, finds an existing copy, and renames the new one to prevent name collision.
Workaround #1 Before adding an existing object, move it to a temp directory outside of your project space. Choose Add Existing package and copy into your project. Package will have correct name.
Workaround #2 After original scenario, delete the original from disk, then rename the copy from within BIDS (Visual Studio). This will rename your package to the correct name.
The method you need to use to get around the "Add Existing Package" behavior is pretty simple. Just right-click on the project and select "Add Existing Item." Doing it this way just attaches the DTSX to the project without renaming or creating a copy.
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