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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
So I install the VS 2010 Shell and get an invalid license data. Reinstall is required. Re-installed and same error
Looks like you got hit by similar problem that other experienced installing stand alone VS2010 shell and please see workarrounds from links below:
http://stackoverflow.com/questions/2673275/how-do-i-fix-an-invalid-license-data-reinstall-is-required-error-in-visual-c
check last comment from here...
https://social.msdn.microsoft.com/Forums/en-US/9ff4bb25-eb12-4554-bea1-d67683ab535d/message-visual-studio-2010-shell-invalid-license-data-reinstall-is-required-when-opening-a-vs2010?forum=vssetup
http://stackoverflow.com/questions/2673275/how-do-i-fix-an-invalid-license-data-reinstall-is-required-error-in-visual-c
check last comment from here...
https://social.msdn.microsoft.com/Forums/en-US/9ff4bb25-eb12-4554-bea1-d67683ab535d/message-visual-studio-2010-shell-invalid-license-data-reinstall-is-required-when-opening-a-vs2010?forum=vssetup
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.
so at this point I think we should be good.
ASKER
thanks