.sln file and editing a package
Hi, I have a wierd problem with my work terminal. It gets restarted abruptly. I keep the saving my work in BIDS. However when the terminal restarts and I open the BIDS for the solution that I am working on- I see many packages which are developed missing from the solution explorer. The packages are present at : C:\Users\duser\Documents\Visual Studio 2008\Projects\proj1\proj1 The above is the location where all the dtsx files get stored. However when I try to paste the package from this location to the BIDS - it changes the name of the package as Pacakge 1.dtsx . It also changes the name of the package at location : C:\Users\duser\Documents\Visual Studio 2008\Projects\proj1\proj1 and generates a new GUID number. I do not want this to happen. I should be able to open the same package with the same guid number as it was previously stored at the location : C:\Users\duser\Documents\Visual Studio 2008\Projects\proj1\proj1 If I were to edit the packages in BIDS how should I do that without having to paste it to the solution explorer ? Also I would want to see the entire list ( the missing packages in BIDS when the terminal restarted ) ? I did save all and as a result all packages are present on this location : C:\Users\duser\Documents\Visual Studio 2008\Projects\proj1\proj1 but just don't know how to import them to see in BIDS without auto changing the name and guid Also I tried looking for the .sln file and could not locate it . Where can I find the .sln file ? Please advice. Thanks, EVA05
August 3rd, 2012 11:13am

In bids you can use add "existing package" (right click project in solution explorer) to add existing packages that are not in the same folder as the solution file. If the package is already in the folder it will get a new name... If the packages are in the same folder you can use the "Show all files" button on top of the solution explorer and then right click the package and choose "include in project"... and then save the project/solution different project, but same button: Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 12:14pm

Hi, Every time I add an existing package to the BIDS -it makes the copy of the original package on the location : C:\Users\duser\Documents\Visual Studio 2008\Projects\proj1\proj1 The problem with this is - it changes the guid of the package. with my master-child packages set up- I cannot afford to have the same package name with an another guid. It will break my run process. There was a solution proposed. Move the concerned package to a different directory and then use add existing pakage. This will help in getting the same package name package.dtsx instead of package1.dtsx BUT the id ( guid) changes. Is there some way without changing package id I can import package in BIDS and edit it with the original package id ? I folowed this- http://stackoverflow.com/questions/3909387/ssis-adding-an-existed-pacakge-actually-added-an-identical-copy but does not help my cause as I need the original package id. Please advice, Thanks, EVA05
August 3rd, 2012 3:50pm

Copy the file to the project folder and use the second option (show all files, include in project)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 4:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics