Post reply

System table containing DTS pkg contents in text format?

  • August 23, 2006 at 10:02 am

    #172206

    Is there a SQL 2000 system table which houses DTS package contents in text format?

    I need to identify all packages containing the string:  sp_Insert_Widgets

    BT

  • August 24, 2006 at 9:03 pm

    #656758

    the only system table is msdb..sysdtspackages.  however it's binary format.

    there is a vbscript out there which will interate through that table and save the packages as structured stored files or vbscript files which are text files.  then you can search through thoses with some basic file IO routines.

    I'ts been a long time since I saw that vbscript file but I'm sure you can find it via google.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply