November 1, 2011 at 1:39 pm
Hi,
I am very new to SSIS, and I was hoping this forum could assist me with a question.
We have several SQL Server 2005 SSIS packages. We have BIDS 2008 and a SQL Server 2005 database.
Are we able to edit and modify 2005 SSIS packages in BIDS 2008? Or do we need to upgrade the packages in order to use BIDS 2008?
November 1, 2011 at 1:55 pm
I use the version of BIDS that came with SQL 2008 R2 Dev Edition to build and edit SSIS packages that get deployed to SQL 2005 Standard Edition servers. Works just fine.
Does that answer what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 1, 2011 at 1:59 pm
Thank you for the quick response.
This is some of the answer I was looking for. We have packages that were created, developed and deployed from BIDS 2005, to SQL Server 2005.
What I am wondering, is if we can use BIDS 2008 to open those packages that we developed in BIDS 2005? I should have included that in my original question.
November 1, 2011 at 2:30 pm
I use the version of BIDS that came with SQL 2008 R2 Dev Edition to build and edit SSIS packages that get deployed to SQL 2005 Standard Edition servers. Works just fine.
Please confirm this. I was under the impression that an SSIS 2005 server would not run an SSIS 2008 package.
November 1, 2011 at 3:21 pm
I am 99.9999999% sure it won't, especially anything with a data-flow..
I think 2008 and R2 will but I'd have to test that for certainty.
I am pretty sure if you try to edit the package with a higher version of BIDS it will want to upgrade the package which means the lower version won't like it.
I will say this that you can have different versions of BIDS installed all at the same time.
CEWII
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply