I have a DTS job (posted in another topic) that checks to see if todays date is the beginning of the fiscal month. If todays date is the begining of the fiscal month it runs through a step (ActiveX Script Task) that will 'kick off' another DTS job. (In the future, I want to be able to have a list of jobs (different reports) within this step.
I have been toying with code in similar to this but cant seem to get it to work:
Set oPKG = CreateObject("DTS.Package")
oPKG.LoadFromSQLServer ".", , , 256, , , , "Fiscal Reward Report 2"
Set oPKG = Nothing
Main = DTSTaskExecResult_Success
I am not strong with VB code. Thank you for any help.