Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to copy a Project Expand / Collapse
Author
Message
Posted Wednesday, March 25, 2009 1:55 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 20, 2014 11:59 AM
Points: 147, Visits: 644
I have a completed project that is very similar to a new one I want to create. Copying it would save time. How do I go about that?
File/Save As and File/Save Copy of .. As both want to create an object for deployment. I want a copy of the entire project that I can edit a couple of pieces of.
Post #683639
Posted Wednesday, March 25, 2009 2:24 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:33 AM
Points: 252, Visits: 1,710
If you have OS access, you can copy and paste the solution folder in Windows Explorer. If you do so, you may need to update component GUIDs in the copy, and you'll want to make sure that you double-check data destinations so that you don't accidentally update an unexpected table.

Not that the latter happened to me when I first cloned a project this way or anything

Post #683671
Posted Thursday, March 26, 2009 12:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 20, 2014 11:59 AM
Points: 147, Visits: 644
I didn't understand what you meant at first with the GUIDs. I started a second instance of BIDS and was able to copy/paste the objects, including Connection Managers, to a new solution.
Then I started editing the objects in the new solution and now I understand. The copied objects contain the GUID of the original property. I just edit and enter the new property by name.
Thanks.
Post #684497
Posted Thursday, January 6, 2011 11:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:44 PM
Points: 43, Visits: 311
I am attempting this same thing and cant seem to follow what you are discussing about the GUIDs. After copying the project my Visual Studio wont open the SSIS package.

Thanks
Scott
Post #1043940
Posted Thursday, January 6, 2011 10:21 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:34 AM
Points: 201, Visits: 675
Just to add. I have about 30 project all about the same, all of them reading Falt files into the Warehouse. I go into Windows Explore and copy and paste the complete project.
Then rename the files in Explorer from say File01.Sln to file02.Sln, same for the Dtsx file as well.
Then using a text editor I open all of the new files and search and replace all File01 with File02 and the destination tables.
But, be warned, I've tried this before in 2005 and every now and again I would get errors that the package is corrupt and can be read, but I've never had this problem in 2008 R2.
And I know I should change the GUID's but I still have to do it, just lazy I guess, but all of it works in any case
Post #1044132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse