|
@dtsrun /S %1 /U %2 /P %3 /N %4 >> %LOGFILE% if errorlevel 1 goto Error echo %TIME% Manual DTS package end......... >> %LOGFILE% echo ------------------------------------------ >> %LOGFILE% PAUSE goto FINISH :Error echo ------------------------------------------- >> %LOGFILE% echo DTSRUN ERROR PLS CHECK LOG ......... echo %TIME% GlobalStore Backup abnormal end. >> %LOGFILE% pause goto FINISH :Usage echo. echo Usage:crundts %1 servername %2 use_name %3 password %4 dts_name :FINISH 4.保存该文件： 然后你可以在任何程序中调用，也可以手工执行，输入参数 5.测试运行： 在DOS提示符下运行：CRUNDTS SERVERNAME sa password DTS_ExcelToSqlserver 6.日志信息： 10:24:29.38 Manual DTS package start run......... ------------------------------------------ DTSRun: Loading... |
正在阅读：如何在客户端调用SQLSERVER的DTS包?如何在客户端调用SQLSERVER的DTS包?
2004-04-01 13:25
出处：PConline
责任编辑：linjixiong
键盘也能翻页，试试“← →”键
