Link to home
Start Free TrialLog in
Avatar of EA-170
EA-170

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of EA-170
EA-170

ASKER

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
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.
Avatar of EA-170

ASKER

So I install the VS 2010 Shell and get an invalid license data. Reinstall is required.  Re-installed and same error
Avatar of EA-170

ASKER

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.