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

SSIS Recreate Directory Structure Expand / Collapse
Author
Message
Posted Tuesday, November 30, 2010 7:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 24, 2011 1:05 PM
Points: 14, Visits: 42
Our project had dozens of SSIS projects deleted. The hundred of files have been recovered, but in one folder without the original directory structure. Is there a file that can be viewed that will show the original directory structure of each project so we can manually recreate and repopulate it?


Post #1027986
Posted Friday, December 03, 2010 5:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:24 PM
Points: 7,074, Visits: 6,235
If you can open up the SSIS packages in BIDS (doubtful if they've lost their project connections), then you can see the path in the Properties window by highlighting the package name in Solution Explorer.

The other option is to see if you can access the XML version of the package and look for a property called "Full Path".


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1029777
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse