How To Execute Custom task - 08-30-2005 , 07:38 AM
Can can any bady help me to call custome task
here is small snipet
CallSP("EXEC USP_DeleteReportingRecords 'Month To Date Half Hourly Report',
set oPkg = DTSGlobalVariables.Parent
set oExecSQL= oPkg.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTa sk
oExecSQL.SQLStatement = Strsql
set objTask = oPkg.Steps("DTSStep_DTSExecuteSQLTask_1")
objTask.ExecutionStatus = DTSStepExecStat_Waiting
' I would like to run DTSExecuteSQL here it self.
Set oExecSQL = Nothing
Set oPkg = Nothing
CallSP = DTSTaskExecResult_Success
I written this function in ActiveX Script. this will be called n number of
before success of ActiveX script, executeSQL Task will be called.
I wating for your valuable responce.
Thanks and Regards,
Re: How To Execute Custom task - 08-30-2005 , 02:57 PM
Sounds like you want a loop and I have never needed to execute a task by itself through
the object model.
Try and adapt this
Looping, Importing and Archiving
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
On Tue, 30 Aug 2005 05:38:50 -0700, "Rajesha" <Rajesha (AT) discussions (DOT) microsoft.com> wrote:
Re: How To Execute Custom task - 08-31-2005 , 10:38 PM
I not able to execute custom task. instead of executing SP in Execute SQL
task. I used OSQL DOS command utility from vb Script..
C:\>osa -Usa -Pods -S3184.108.40.206 -dArchival -Q "USP_DeleteReportingRecords
'MonthToDate AHT Report', '07/06/2005'"
Thanks for your responce.
"Allan Mitchell" wrote: