Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2011-11-05 : 09:47:34
|
| There 2 issues i have 1) I have opened the existing save ssis package of 2005 version in sqlsever 2008 BI studio and it looks like the version has upgraded.How do i check if the packages are upgraded 2008 and if upgraded to 2008 how to rollback to 2005.2)How do i edit the saved package in sqlserver 2005 with sql login.Thanks for your help in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-05 : 13:29:21
|
| 1, it will automatically get upgraded once you open it in 2008. else it will be in 2005 format2,you need to know the password of sql login as under default protection level it wont save it. so unless you enter it connection manager will fail------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2011-11-05 : 15:09:48
|
| Thanks Visakh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-06 : 02:36:57
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Packages