by Guest
9 Jun 2005 14:00
This is something you may run into, especially if you're running Integration
Services on a machine with multiple instances and at least one of them is a SQL
2K instance.
The Integration Services server does not support instances, but is aware of
SQL Server instances and can be configured to reference a particular instance.
Here's how.
There is a file called MsDtsSrvr.ini.xml in the %PROGRAM FILES%\Microsoft SQL
Server\90\DTS\Binn folder. If you open that file you'll see something like
this:
<?xml version="1.0" encoding="utf-8"?>
...
[More]