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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2011-10-12 : 12:08:12
|
| Hello...I am trying to export a SSIS package by logging into Integration Services.I right click on the package and select Export PackageI choose to save the package to file systemthe protection level does not have have option to rely on server storage etc...Question 1: Will I be able to open this package in BIDSQuestion 2: Will this have any affect on the original packageTIA for any suggestion..as I don't want to mess up the original package in production.R/P |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-12 : 12:16:03
|
| you will be able to open it in BIDS by adding it to project of type Integration services project. But if it has protection level of save sensitive with password/user id and if you dont have password or is not creator of package you will not be able to view sensitive information like sql login password etcIt will not have any effect on original package stored in server as you're getting just a working copy. Unless you deploy it back with any change, the original version will stay unaffected------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2011-10-12 : 16:04:35
|
| Thank you!Now 1 more question, please...How do I export a Legacy package in sql 2005? Do yo know of a step by step procedure I could follow?R/P |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Saving SSIS Package to File