I have SQL Server 32 bit on my machine. I ran an import export job the other day and wanted to save it. I picked save it to file and I found it strange it never asked me where to save it. So this morning I decided to have a look for it and found that it saves it in the instance you were in at the time.
I also found the execute package in all programs so ran this and the window came up but with execute button grayed out. At the bottom of the window it says, amongst other things, that you need management tools basic to run, but I already have this installed.
When I go into the installation center it shows management tools basic as being selected, however the ticks are grayed out too.
Never really fathomed out SQL server installs, seems you have to keep running this installer to fix things and then I don't understand why they are grayed out. If memory serves me right the tick boxes for management tools - basic were ticked the first time I installed and grayed out too.
What is wrong and how can I set up to allow packages to be run?