SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Thursday, August 03, 2006

Executing Batch Files Using SQL Agent

I wrote a simple batchfile which takes a copy of our source files. I wanted to execute that via SQL Server Agent. Batchfile works fine when I execute on a command prompt.

To get the batch file to execute via SQL Agent I have to use CALL command.

In my scenario
CALL E:\Data\FTP\CopySourceFiles\SourceFile_Backup.bat

Thanks
Sutha

Tuesday, August 01, 2006

Shredding Recordset Object In ForEach Loop - While Using Checkpoint - Bug Fixed

Following my earlier post, I raised a bug and I have been informed my Microsoft Connect team this bug has been fixed and the fix will be available on SP2. Quote from MS Connect below:

"The bug was identified as a same known issue which was fixed already for our next release, however, after considering the problems involved in this bug issue, we decided to also port the fix into our next Yukon service pack, SP2. You should be able to get the fix after applying SP2."

Thanks
Sutha