srinivasable (4/21/2010)
Hi,We have 2 clients. one client is using SQL2008 and the other client is using SQL2005.
I want use 1 set of packages (2005 SSIS packages with Konesans 2008 component).
Thank you
Srini
Srini,
There is no way you can use one and same package for both 2005 and 2008. What you can do is implement your package in 2005 and then whenever you have to make changes, make them in the 2005 version. Then use 'Add Existing Package..." command in 2008 solution and the SSIS framework will hopefully upgrade the package without issues to 2008. However for this to work your machine has to have both:
- SQL 2005 and 2008 installed
- Konesans component for 2005 an 2008 installed
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
