SSIS - Viewing packages in Management Studio
Its odd how you often find things out by accident.
Yesterday I was copying a dts package into a folder on my server and for some
reason the drop didn't drop. When I then switched to management studio and XP
finally decided to drop the file it did it in the management studio work space.
At first I was a confused I wasn't sure what had happened. The reason for the
confusion was that the package was there in all its technicolor control flow
glory, tasks, containers constraints etc in Management Studio. I had to do
double take as I had the package open in visual studio as well. After the
confusion it was clear that you can view packages in management studio.
Now I am not sure if this is by design or just a symptom of using the
VSShell. I suspect the later but on thinking it must be the former because of
maintenance plans. The limitations are, you can't execute the package, you can't
see the variables window (which I would say is a mistake), the toolbox only has
maintenance tasks in it.
-