Post reply

SSIS Recreate Directory Structure

  • November 30, 2010 at 7:38 am

    #243402

    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?

  • December 3, 2010 at 5:21 am

    #1258314

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply