July 19, 2010 at 9:15 am
I am developing a SSIS package in 2008 R2 and my PROD Server has sql server 2005 installed on it. Do you think there will be any compatibility issues while deploying it on 2005 server?
July 19, 2010 at 9:18 am
Yes, definitely. You will have to re-do your development in 2005. There is no 'Save As' function.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
July 19, 2010 at 9:47 am
I dont have a 2005 sql server for developing. Is there any other way to solve this problem
July 19, 2010 at 9:55 am
Unfortunately not. There's no backward compat option with SSIS, no save as, no downgrade. If you're deploying to a SQL 2005 server, you need to write your package in BIDS for SQL 2005.
Been there, done that, had the fun of rewriting an entire package... 🙁
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2010 at 2:04 pm
Unfortunately I agree with everything. Re-write is your only option. You might be able to cut and paste some raw code between but not objects.
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply