REM Objective: Load DTS package and save it to SQL Server
REM Type: Batch File to get all DTS package name
REM Created by: MAK
REM Contact: mak_999@yahoo.com
REM Date: Sep 17, 2004
REM Parameters %1 = SQl Server box name %2 = directory name
@Echo on
 
REM Export DIR listing to C:\MyImport\Dirlist.txt

Echo "Load Started" 
Date/t 
time/t 
dir %2 /b > C:\RestoreDTS\Dirlist.txt

REM Restore all the DTS package listed in C:\RestoreDTS\Dirlist.txt

for /f "tokens=1" %%i in (C:\RestoreDTS\Dirlist.txt) do Cscript /nologo RestoreDTS.vbs %1 %2%%i 

REM echo %2%%i
Echo "Load Completed" 
Date/t 
time/t