I have a package connecting to multiple SQL instances and pulling back data. The package reads the connection strings from a table within SQL.
This works fine for 2012, 2008, 2005 but obviously not for SQL 2000.
Will i need to have a seperate connection manager just for the SQL 2000 instances we have, or is there a way to make SSIS connect to SQL 2000 with native client 11?
or is there a connection manager that will work for all!?