SQLServer data transformation packages location?

[GilletteCat]

I need to find out where SQL Server 2000 stores its local packages (data transfer/modification ones). When I created data transformation packages, I did not save them as VB modules, but rather as local to SQL Server. Is there a way to locate them on my system?
Appreciate all your help!

 

[BuckleDownBen]

You can save a DTS package 3 ways.

1) VB module
2) SQL Server
3) Structured storage file

1 and 3 are actual files. I don't know where 2 is stored. I think what you need is 3. If you right-click on Data Transformation services, you can select Open Package, which will let you open a package you saved as 3. I use this to put a package on a CD to giver to a client to run.

Hope this helps-

Ben

 

[GilletteCat]

Well, it is not an option for me to choose the type of package. I am trying to recover the stuff from lost installation of SQL Server. Thanks for the advice though, I will do that way in the future. But I am trying to find out if I can somehow recover the DTS packages saved to local SQLServer. There is got to be a place where it puts them! I hope its not the registry that holds the descriptors for such type packages, because its the thing that led to the situation I'm in

Any help is appreciated.

 

[BuckleDownBen]

Sorry, I misunderstood your question. I don't have a lot of time to help you, but this might lead you onto the right path. In the msdb databse, there is a table named sysdtspackages. maybe you can do a google search to dig up more information?