February 27, 2006 at 9:10 pm
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
March 1, 2006 at 2:46 am
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
March 1, 2006 at 3:26 am
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