Change Owner of a SSIS package

• Data9

  SSC-Addicted

  Points: 453

  More actions

  October 16, 2008 at 11:01 am

  #124287

  I want to change owner my created packages, because on production my login may not have access. Confict coming with ID parameter

  Msg 14262, Level 16, State 1, Procedure sp_reassign_dtspackageowner, Line 31

  The specified DTS Package ('Name = ' }.{[not specified]}') does not exist.

  [font="Arial"][/font]

  I am using this

  EXEC sp_reassign_dtspackageowner

  I appreciate your quick help.

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 17, 2008 at 11:00 am

  #886519

  Please don't post multiple times with the same question. sp_reassign_dtspackageowner only works with DTS packages, not SSIS packages. See my reply in this thread: http://www.sqlservercentral.com/Forums/Topic587199-148-1.aspx

  Greg