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

  • 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

  • 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

     

  • Thanks,

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

    Dick campbell

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

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