Please start any new threads on our new site. We've got lots of great SQL Server experts to answer whatever question you can come up with. How To Apply A Patch With Patch. Our new are live! Come on over!
We've restricted the ability to create new threads on these forums. SQL Server Forums Username: Password: Save Password DTSRun in batch file Author Topic Yak Posting Veteran 74 Posts Posted -: 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, Bill DTSRUN /S MySvr /E /N ETL_Dly_Trans_Staging_Pkg /A 'TX_PATH':'8'=' MySvr DBDATA TSYS DATA ' IF%ERRORLEVEL% EQU 1 GOTO ERROREXIT ECHO CONTINUE ISQL /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 ERROREXIT ECHO CONTINUE:ERROREXIT ISQL /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 Yak Posting Veteran 74 Posts Posted -: 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 Topic Jump To: SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC This page was generated in 0.02 seconds.
/Z Indicates that the command line for dtsrun is encrypted using SQL Server. Without executing the DTS package to use that command line in your batch files. Feb 11, 2005 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.
I know this question has come up often but I have looked through all answers and not found one that worked for me yet. I am simply trying to execute a SSIS Package from a Bat file so I can schedule it to run in the task scheduler. So far the.bat file just opens and immediately closes. Ok thank you, Sorry I am new to all of this I recieved the following error in the log after rerunning it without the space Started: 4:03:08 PM Error: 2012-09-17 16:03:09.90 Code: 0xC0209303 Source: Week Connection manager 'dealer' Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.
The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
An OLE DB record is available. Source: 'Microsoft OLE DB Service Components' Hresult: 0x80040154 Description: 'Class not registered'. End Error Error: 2012-09-17 16:03:09.92 Code: 0xC00291EC Source: Start Execute SQL Task Description: Failed to acquire connection 'dealer'. Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 4:03:08 PM Finished: 4:03:09 PM Elapsed: 1. Logo Font & Lettering Bible Ebook. 609 seconds.