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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy