May 5, 2008 at 3:50 pm
I am trying to decipher some error codes generated by an SSIS. I did not write the SSIS and am new to MS SQL Server 2005. I am trying to find the SSIS and figure out what it is doing. Another post suggested that the SSIS can be stored either on the file system or in a database. Is there a way to query the db for the SSIS?
TIA
DG
May 6, 2008 at 6:20 am
use msdb
select *
from dbo.sysdtspackages90
order by [name]
If you search for sysdtspackages90 in BOL it will give you the definition of these columns.
--The folderID can be found in
select *
from sysdtspackagefolders90
May 6, 2008 at 7:18 am
Thank you, thank you, thank you!
D
May 6, 2008 at 8:28 am
It would be helpful if you had a copy of the original package so you could open and test using the development studio. Does anyone there know who developed the package so you can get a copy?
May 6, 2008 at 8:55 am
Actually, depending on the encryption of the package strored in SSIS, you may be able to export this package from SSMS Intergration Services to a .dtsx disk file, create a new Intergration Services solution in BIDS and then add this package to the solution.
I've done that several times in the past with out existing packages.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply