Author: DURETTE, STEVEN J
I know this is OT, but you guys seem to know a lot about everything. Part of my
job requires that I build SSIS packages for data loads, and some of that data
comes from Teradata. The problem I'm having is that some of the SQL Servers (mix
of 2005, 2008, and 2008 R2) have the Attunity TeraData 1.0 drivers and others
have the 1.1 drivers. If I install the 1.1 version I can't create packages for
the servers with 1.0, and the same for the reverse. Plus I can no longer find the
1.0 drivers at the Microsoft Website.
Does anyone know if you can have both drivers installed on a development machine
to be able to build to any of the available machines.
Also, upgrading the drivers on the servers is not an option at this time, as it
would mean rebuilding hundreds of SSIS packages to use the new drivers.
Thanks for any insight!