March 16, 2011 at 11:11 am
Hi all,
I've installed SQL server 2008 developer edition in my PC & developing some SSIS packages for data load processing. But we have only SQL server 2005 environment.
Will it create any problem in deploying / executing 2008 packages in SQL 2005?
Plz let me know your thoughts / suggestions.
Regards,
Suresh
Suresh
March 16, 2011 at 11:24 am
You can't run packages developed in BIDS 2008 on an SSIS 2005 instance. You must develop your packages in BIDS 2005. No, you can not open your 2008 packages in BIDS 2005 either.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
March 17, 2011 at 9:08 am
Thanks for your response.
I was trying to open the 2005 version package in BIDS 2008. It was throwing following error:
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.
I was expecting that SQL 2008 will have backward compatability so that i will be able to open / exec previous version of SQL also.
can you plz share your comments.
Suresh
March 18, 2011 at 1:09 am
Well, it has backward compatibility: you can upgrade 2005 packages to 2008.
SSIS 2005 doesn't have forward compatibility: you can't design 2008 packages using BIDS 2005.
Regarding your error: you can't connect with BIDS 2008 or SSMS 2008 to an SSIS 2005 server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 20, 2011 at 9:52 pm
You can open 2005 packages in BIDS 2008 - it will automatically upgrade them. You won't then be able to execute them under 2005 anymore.
You can connect SSMS 2008 to an SSIS 2005 "instance" - but there's not much need to do so. Where do you store your packages once they're deployed?
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
March 21, 2011 at 1:26 am
tmcdermid (3/20/2011)
You can connect SSMS 2008 to an SSIS 2005 "instance" - but there's not much need to do so.
Are you sure? I always got an error when I tried that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 13, 2012 at 5:10 am
Koen Verbeeck (3/21/2011)
tmcdermid (3/20/2011)
You can connect SSMS 2008 to an SSIS 2005 "instance" - but there's not much need to do so.Are you sure? I always got an error when I tried that...
You can, but it's not recommended.
http://support.microsoft.com/kb/2466166
Also once you run the package using the SSIS 2008 package execution tool, it will upgrade the package on the 2005 server, so you won't be able to execute it. Just run 2005 side by side with 2008 if you need to.
July 13, 2012 at 5:15 am
Eric Hobbs (7/13/2012)
Koen Verbeeck (3/21/2011)
tmcdermid (3/20/2011)
You can connect SSMS 2008 to an SSIS 2005 "instance" - but there's not much need to do so.Are you sure? I always got an error when I tried that...
You can, but it's not recommended.
http://support.microsoft.com/kb/2466166
Also once you run the package using the SSIS 2008 package execution tool, it will upgrade the package on the 2005 server, so you won't be able to execute it. Just run 2005 side by side with 2008 if you need to.
Thanks for answering my 1+ year old question 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 13, 2012 at 8:21 am
Eric Hobbs (7/13/2012)
Also once you run the package using the SSIS 2008 package execution tool, it will upgrade the package on the 2005 server, so you won't be able to execute it. Just run 2005 side by side with 2008 if you need to.
That's not accurate to my recollection. If you run a 2005 package with SSIS 2008, it upgrades the package in-memory - it doesn't upgrade the package in the stored location...
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
July 13, 2012 at 8:24 am
That's correct. I did not read the article carefully enough 🙁
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply