Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-02-26 : 03:17:11
|
| Hi,In SQL 2000, we can import the DTS packages into SQL Server MSDB database for a Named Instance.But in SQL 2005 and am not able to save/deploy the SSIS package in MSDB database???Is there any work around to save in MSDB or else do we need to LIVE with saving the package in File system and using a stored procedure i.e DTExec utility we need to call that package???????Any thoughts???? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-26 : 10:43:41
|
| Deploy them to the default instance. SSIS service doesn't support multiple instances. |
 |
|
|
|
|
|
Cannot deploy ssis package on a Named Instance