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.
| Author |
Topic |
|
billsox
Yak Posting Veteran
74 Posts |
 Posted - 2005-02-11 : 14:28:38
|
| Hi -- I've got a batch file that calls the DTSRun utility to import a text file into SQL Server (excerpt below). The loading works perfectly. Problem is that once DTSRun command finishes, the remainder of my batch file never runs. My system just hangs when the package finishes. Any idea what might be going wrong? Thanks in advance,BillDTSRUN /S MySvr /E /N ETL_Dly_Trans_Staging_Pkg /A "TX_PATH":"8"="\\MySvr\DBDATA\TSYS\DATA\"IF %ERRORLEVEL% EQU 1 GOTO ERROREXITECHO CONTINUEISQL /S%1 /dpercurr /E /e /b /Q "insert into tbl_ETLLog select count(*) from dbo.t_per_trans_t where record_type = 'd'"IF %ERRORLEVEL% EQU 1 GOTO ERROREXITECHO CONTINUE:ERROREXITISQL /S%1 /dpercurr /E /e /b /Q "exec Job_End_stream_P 'percurr_trans','003','001', '0','F',1,'Load into t_per_trans_t failed','trans'"ECHO Ended due to failure:END |
|
|
billsox
Yak Posting Veteran
74 Posts |
Posted - 2005-02-11 : 15:01:25
|
| Answered my own question...Apparently the /W switch is necessary for writing the package completion status to the Windows Application Log. Setting it to True allows the batch file to continue processing. See Books Online for more info on the DTSRun topic.Bill |
 |
|
|
|
|
|
DTSRun in batch file