Good day, i need help.
Migrating Servers & SQL from 2005 to 2008.
We have a package that 1.extracts data & 2.process cognos cubes on the old server, do not want to install Cognos on new server as it will be discontinued in a few months. Old server will also be trashed soon.
I have been asked to manually check when 1.extracts data pkg has completed & then Manually 2.process cognos cubes on my PC.
I do not want want this, Is there a way from within the one pkg or agent to Remotly execute another pkg on my PC?
Please Assist, really would be great if i could do this.
View Complete Post