Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Text search in DTS

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-12-10 : 04:39:39
Hey,

Is there a way where i can see whether the particular table is used in the list of DTS packages stored in the database. or I'm also trying to save the dts packages to .bas file so that i can search the particular pharse but could not achieve as its saving it in encryped format. Pls. see the following commands.

EXEC MASTER..XP_CMDSHELL 'DTSRUN.EXE /S TEST /E /N "TEST" /F "E:\DTS\TEST.BAS" /!X'

Thanks in advance.
   

- Advertisement -