<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
测试环境:
服务器:PIII866+512MB+RAID5
WINDOWS2000SERVER+SP4; SQLSERVER2000+SP3
客户端:WINDOWS2000PRO+SP4+ SQLSERVER2000CLIENT+SP3
1.先在SERVER端建立一个 DTS包:
这可以根据向导一步一步的完成,我就不多说了。比如我门建立了一个导入EXCEL文件到 SQLSERVER的 DTS包: DTS_To SQLSERVER
2.在客户端建立一个批处理文件
CRUN DTS.BAT
3.用文本编辑器编辑:
@@echooff
if[%1]==[]gotoUsage
if[%2]==[]gotoUsage
if[%3]==[]gotoUsage
if[%4]==[]gotoUsage
cls
SETLOGFILE=c:/ DTSRUN.LOG
echo%TIME%Manual DTSpackagestartrun.........>>%LOGFILE%
echo------------------------------------------>>%LOGFILE%
@ DTSrun/S%1/U%2/P%3/N%4>>%LOGFILE%
iferrorlevel1gotoError
echo%TIME%Manual DTSpackageend.........>>%LOGFILE%
echo------------------------------------------>>%LOGFILE%
PAUSE
gotoFINISH
:Error
echo------------------------------------------->>%LOGFILE%
echo DTSRUNERRORPLSCHECKLOG.........
echo%TIME%GlobalStoreBackupabnormalend.>>%LOGFILE%
pause
gotoFINISH
:Usage
echo.
echoUsage:crun DTS%1servername%2use_name%3password%4 DTS_name
:FINISH
4.保存该文件:
然后你可以在任何程序中调用,也可以手工执行,输入参数
5.测试运行:
在提示符下运行:CRUN DTSSERVERNAMEsapassword DTS_ExcelTo SQLSERVER
6.日志信息:
10:24:29.38Manual DTSpackagestartrun.........
------------------------------------------
DTSRun:Loading...
Error:-2147217900(80040E14);ProviderError:14262(37B6)
Errorstring:
Errorsource:
Helpfile:
Helpcontext:0
10:24:29.66Manual DTSpackageend.........
------------------------------------------
10:27:29.41Manual DTSpackagestartrun.........
------------------------------------------
DTSRun:Loading...
DTSRun:Executing...
DTSRunOnStart: DTSStep_ DTSDataPumpTask_1
DTSRunOnProgress: DTSStep_ DTSDataPumpTask_1;23Rowshavebeentransformedorcopied.; PercentComplete=0;ProgressCount=23
DTSRunOnFinish: DTSStep_ DTSDataPumpTask_1
DTSRun:Packageexecutioncomplete.
10:27:30.02Manual DTSpackageend.........
------------------------------------------ <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
经常有网友问起如何在
客户端调用
SQLSERVER服务器端的一些脚本和对象,并且可以输入参数,我就举例说明一下如何在
客户端调用
SQLSERVER的
DTS包,并且可以输入参数,并且可以记录日志:
测试环境:
服务器:PIII866+512MB+RAID5
WINDOWS2000SERVER+SP4; SQLSERVER2000+SP3
客户端:WINDOWS2000PRO+SP4+ SQLSERVER2000CLIENT+SP3
1.先在SERVER端建立一个 DTS包:
这可以根据向导一步一步的完成,我就不多说了。比如我门建立了一个导入EXCEL文件到 SQLSERVER的 DTS包: DTS_To SQLSERVER
2.在客户端建立一个批处理文件
CRUN DTS.BAT
3.用文本编辑器编辑:
@@echooff
if[%1]==[]gotoUsage
if[%2]==[]gotoUsage
if[%3]==[]gotoUsage
if[%4]==[]gotoUsage
cls
SETLOGFILE=c:/ DTSRUN.LOG
echo%TIME%Manual DTSpackagestartrun.........>>%LOGFILE%
echo------------------------------------------>>%LOGFILE%
@ DTSrun/S%1/U%2/P%3/N%4>>%LOGFILE%
iferrorlevel1gotoError
echo%TIME%Manual DTSpackageend.........>>%LOGFILE%
echo------------------------------------------>>%LOGFILE%
PAUSE
gotoFINISH
:Error
echo------------------------------------------->>%LOGFILE%
echo DTSRUNERRORPLSCHECKLOG.........
echo%TIME%GlobalStoreBackupabnormalend.>>%LOGFILE%
pause
gotoFINISH
:Usage
echo.
echoUsage:crun DTS%1servername%2use_name%3password%4 DTS_name
:FINISH
4.保存该文件:
然后你可以在任何程序中调用,也可以手工执行,输入参数
5.测试运行:
在提示符下运行:CRUN DTSSERVERNAMEsapassword DTS_ExcelTo SQLSERVER
6.日志信息:
10:24:29.38Manual DTSpackagestartrun.........
------------------------------------------
DTSRun:Loading...
Error:-2147217900(80040E14);ProviderError:14262(37B6)
Errorstring:
Errorsource:
Helpfile:
Helpcontext:0
10:24:29.66Manual DTSpackageend.........
------------------------------------------
10:27:29.41Manual DTSpackagestartrun.........
------------------------------------------
DTSRun:Loading...
DTSRun:Executing...
DTSRunOnStart: DTSStep_ DTSDataPumpTask_1
DTSRunOnProgress: DTSStep_ DTSDataPumpTask_1;23Rowshavebeentransformedorcopied.; PercentComplete=0;ProgressCount=23
DTSRunOnFinish: DTSStep_ DTSDataPumpTask_1
DTSRun:Packageexecutioncomplete.
10:27:30.02Manual DTSpackageend.........
------------------------------------------ <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>