25112
asked on
SSIS 2005 - range of SQL servers it had reach
can SSIS 2005 package be able to hit any sql server database on the market now?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
1)when you say "specific features of these versions", can you give an example, please?
2)is the same true for SSIS R2 package : can it hit 2000/5/8/denali data? - same as 2005, only more new features.
2)is the same true for SSIS R2 package : can it hit 2000/5/8/denali data? - same as 2005, only more new features.
if you are in 2000 compatibility mode, don't try anything related to spatial, date, datetime2, ... datatypes
ASKER
thanks.. could you also confirm
2)is the same true for SSIS R2 package : can it hit 2000/5/8/denali data?
2)is the same true for SSIS R2 package : can it hit 2000/5/8/denali data?
That I cannot
ASKER
that is fine - is it because you have no tried that yet?
I am not a big user of SSIS. I use that data part every day but not SSIS
ASKER
OK- thanks; I will confirm in the 2008 zone then. appreciate it, emoreau:.
ASKER
sql 2000
sql 2005
sql 2008
sql 2008 R2
sql Denali
from one package, if need be, can i have 5 connection strings to the above 5 versions of databases?