Opening a Deployed SSIS Package

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  February 6, 2015 at 3:51 am

  #295189

  Hi all - I have been handed a datawarehouse environment to look at however I cannot find the ssis packages (.dtsx).

  I see that the packages have been deployed to SSISDB but I can't find the files to load into Datatools.

  Once the files have been deployed is it possible to remove the package files? Is there a way of retro'ing the deployed packages out of SQL so I can view them in Datatools?

  Thanks!

  --------------------------------------------

  Laughing in the face of contention...

• CooLDBA

  Hall of Fame

  Points: 3301

  More actions

  February 9, 2015 at 6:35 pm

  #1776516

  Better to post at Data Warehousing » Integration Services Forum

• Jason-299789

  SSC-Insane

  Points: 21601

  More actions

  February 10, 2015 at 1:28 am

  #1776552

  This link should help

  http://www.mssqlgirl.com/editing-published-ssis-package-in-sql-server-2012.html

  I haven't tried to do this.

  _________________________________________________________________________
  SSC Guide to Posting and Best Practices