SSIS packages deployed by consultant

[Peter]

We have many SSIS Packages running in Jobs maintained through SSMS. I can
connect to Integration Services in SSMS and see the Stored Packages in MSDB,
but how do you find the .sln file for some dtsx packages so I can fix them in
BIDS VS2005? Is there a table in msdb with this information?

[Gerald Aichholzer]

Hello Peter,

Post by Peter
We have many SSIS Packages running in Jobs maintained through SSMS. I can
connect to Integration Services in SSMS and see the Stored Packages in MSDB,
but how do you find the .sln file for some dtsx packages so I can fix them in
BIDS VS2005? Is there a table in msdb with this information?

as far as I know you have to export the packages to the file system,
modify them with BIDS and then reimport the modified packages. If
there's a better solution please let me know.

regards,
Gerald