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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-12-20 : 16:52:28
|
| I've read how I need to update MsDtsSrvr.ini.xml to replace "." with the name of my named instance. For example, in the script below I replaced "." with "MYSERVERNAME\MYINSTANCENAME". When I connect to Integration Services do I specify the named instance in the connection string or the default instance? I'm unable to connect specifying the named instance.<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>MYSERVERNAME\MYINSTANCENAME</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>Thanks, Dave |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 17:39:38
|
| SSIS is per host not per sql instance, xml file just specifies where to find msdb. When connect to SSIS, it only let you choose machine to connect to. |
 |
|
|
|
|
|
Updating MsDtsSrvr.ini.xml for Named Instance