I ran the Export wizard to output some data to Excel, and I saved the package to run agan later. I now want to edit the SQL used to generate the Excel, but it is not clear how I do this.
The package is visible (in Stored Packages > MSDB) in SSIS, and I can execute it again, but I don't see a means to edit it. I also opened Business Intelligence Studio, through which I could see how to open a package stored as a file, but not how to open a package automatically stored in MSDB.
Can anyone point me in the right direction?