Home Forums Data Warehousing Integration Services How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly RE: How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

  • John Rowan (9/30/2016)


    All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual Studios, start a blank project, right-click on the SSIS Packages folder in the Solution Explorer, and select 'Add Existing Package'. Then you have them in your solution for editing.

    Thanks, this helps. So as I learn, the next price I have to understand that you said was to place it where it is viewable by the Server Agent, and I'm not so sure what or how to assure that. I'm going to copy the .dtsx files to the share drive and step through what you outlined.