I've saved some .dtsx integration packages, which do run, to the SQL Server instance rather than the file system.
I'd like to clean these up and redo them, but I can't find a way to access and delete them. I've attempted connecting to the server using integration services, but I get a "Specified service does not exist as an installed service"
I've been trying to find how to enable the service, but everything I've seen seems to lead me to a full reinstall which is not a viable solution at this time.
If I'm missing some documentation which shows how to enable the services on an already installed instance that'd be plenty, but if not I'd like to know if there's some other way to access these files so I can clean them up and replace some of them without having to point everything to a local folder.
Without integration services installed you cannot access these packages if they are stored in SQL Server database (not File System).
Referring to Package Management documentation:
By default, the Stored Packages folder contains two folders: File System and MSDB. The File System folder lists the packages that are saved to the file system. The location of these files is specified in the configuration file for the Integration Services service. The default folder is the Packages folder, located in %Program Files%\Microsoft SQL Server\100\DTS.
The MSDB folder lists the Integration Services packages that have been saved to the SQL Server msdb database on the server. The sysssispackages table contains the packages saved to msdb.
To view the list of packages in the package store, you must open SQL Server Management Studio and connect to Integration Services.
Additional Information