Requirements to edit SSIS Packages

We have a programmer that built a bunch of SSIS packages and we have an analyst that maintains and runs these packages.  She has SQL Server 2012 standard installed on her laptop but she is leaving for vacation and someone needs to be her backup.  She is able to open, run, and edit the SSIS packages using VisualStudio 2010 Shell.  As we prepare for her vacation and trying to find the correct information on this has been highly confusing...  
The backup person, do I need to install sql server standard on his laptop so he can edit and run the SSIS packages or can I use SQLExpress or can I just install VisualStudio 2010 Shell?

Thanks
EA-170Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Where are the packages stored/executed from? If they are not on her local "SQL Server 2012 standard installed on her laptop " then the backup person does not need that installed but SQL 2012 Management Studio, VisualStudio 2010 Shell and the exact same level of authority against that SQL Server as the person that leaves on vacation.

You can get SSMS Express tools from here or full SQL Server Eval tools from here.
http://www.microsoft.com/en-us/download/details.aspx?id=43351

MSDN/TechNet Downloads
http://www.microsoft.com/betaexperience/pd/SQL2012EvalCTA/enus/default.aspx
is currently the only place to get RTM versions (non-eval) of the SSMS 2012 toolset.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EA-170Author Commented:
the SSIS packages are up on a file server share. I was able to find after some serious digging on either MS or MSDN download site the VS 2010 Shell installer.

thanks
lcohanDatabase AnalystCommented:
You can get "Microsoft Visual Studio 2010 Shell (Isolated) Redistributable Package" here:

http://www.microsoft.com/en-ca/download/details.aspx?id=1366

As far as to edit and run the packages against that SQL Server all needed is SSMS 2012 and the appropriate identical SQL permissions identical to the person that leaves on vacation.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

EA-170Author Commented:
So I install the VS 2010 Shell and get an invalid license data. Reinstall is required.  Re-installed and same error
lcohanDatabase AnalystCommented:
EA-170Author Commented:
Yes - I ended up just installing from the SQL 2012 standard tools and mgmt studio.  Still get a few random errors about visual studio, but it runs the packages without issue...

so at this point I think we should be good.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.