SQL Server 200o Default Instance - What are SSIS Package Storage Options

• Dick Campbell

  SSChasing Mays

  Points: 647

  More actions

  February 27, 2006 at 9:10 pm

  #365352

  I have SQL Server 2000 as the default instance and SQL Server 2005 as a named instance (for historical reasons). The SSIS Server does not support named instanaces so where do the Packages get stored, on SQL Server 2000 or 2005?

  While on the subject, when you "Import" a file system package into "\Stored Packages\File System does" the package actually get stored on the SQL Server or is it just "registered". Also, if you execute the pacakge by calling from a remote computer, does the package actually execute on the SQL Server (the age old question).

  Thanks,

  Dick Campbell

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  March 1, 2006 at 2:46 am

  #623888

  The SSIS server DOES support SSIS instances. Sort of: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx

  The package executes wherever you call it from. The SSIS server does not execute packages. The package simply executes under a process.

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson

• Richard Campbell

  Old Hand

  Points: 380

  More actions

  March 1, 2006 at 3:26 am

  #623895

  Thanks,

  I will try it tomorrow (it is Wednesday night here).

  Dick campbell