SSIS and SQL Server Instances

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]

Popular this month

No post views yet...