This has bugged (pun?) me for some time, and I wonder if I am just nuts: I hesitate to log in to a production server with Remote Desktop and run SSMS there, preferring to do all I can with SSMS running on my local workstation instead. However, in both SSMS 2005 and 2008 there's this strange behavior when setting up an Integration Services package for SQL Server Agent: the GUI demands the package be specified using a local disk instead of a disk from the server, which of course is impossible:
- Open SSMS and connect to a remote server
- Create a new SQL Server Agent job
- Create a step with type SQL Server Integration Services Package
- Choose the File System as the source (we deploy SSIS packages as files)
- Click the Ellipsis (...) button
- I then get the rather unhelpful My Documents folder on my C: drive.
Most other server-related dialogs give you server filesystems (backup or restore, for example.) Is this just a long-overlooked bug, or am I crazy?