Data Transformation Services - Local Packages - Location of Files RRS feed

  • Question

  • We have recently had a server crash and we have had to reload onto new system hard drives.  The OS and SQL Server 2005 have loaded fine and we have successfully restored the SQL databases. Our problem is that we had a number of DTS local packages defined and although we can access the data from the old system, I cannot find any reference to the package names/file names or folder locations.  I have created a new test local package on the working sql and then searched for its name within the program files/sql server folders, but again I cannot locate the file.

    Can any please point me in the direction of the local package files or the system file that contains this data.

    Many thanks 

    Saturday, April 16, 2011 9:53 AM


  • Were these packages at the file system level or installed in MSDB of SQL server ? Check the folder C:\Program Files\Microsoft SQL Server\90\DTS\Packages . Did you try to connect to integration services for accessing the package ?
    Thanks, Leks
    Monday, April 18, 2011 1:09 AM