Where does sql store the connection information

[kodaksmile]

Hi all,

Does anyone know where in sql (msdb) the connection information (specifically username and password) are stored for dts packages?

Thanks,

 

[mrdenny]

They are stored within the DTS package in the msdb.dbo.sysdtspackages table.

You won't be able to read the information as DTS packages are stored in a binary form.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com