echo ***************************************
@echo Oracle→SQLServer
@echo ***************************************
@echo off
@SET W_CONNECT=ok/ok@ok
@SET SQLFILES=.\sql\*.sql @for %%a in (%SQLFILES%) do (
echo %date% %time% @%%a CSV做成开始 >> log.txt
SQLPLUS -S %W_CONNECT% @%%a
echo %date% %time% @%%a CSV做成完了 >> log.txt
)csv文件都做出来了,为什么没有写进log呢?
@echo Oracle→SQLServer
@echo ***************************************
@echo off
@SET W_CONNECT=ok/ok@ok
@SET SQLFILES=.\sql\*.sql @for %%a in (%SQLFILES%) do (
echo %date% %time% @%%a CSV做成开始 >> log.txt
SQLPLUS -S %W_CONNECT% @%%a
echo %date% %time% @%%a CSV做成完了 >> log.txt
)csv文件都做出来了,为什么没有写进log呢?
下面的这个命令删除就正常出log了,这个问题怎么解决呢?不能不执行这个命令阿
sqlcmd -Q "delete FROM %DB_NAME%.dbo.MST_BRANCH" %CONN_PARAM%