Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


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 3, 2010 5:21 AM



Group: General Forum Members
Last Login: Today @ 11:56 AM
Points: 7,508, Visits: 8,664
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

LiveJournal Blog:
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