I am working with a client that had a cube created some time ago and we believe it was done when they were using SS2000 and now they are at SS2005. I need to modify the update of the cube. There is a job that is being run every hour and I need to modify it. Help me understand how I get this done. SSIS is NOT installed on the server.
Here is the only step in the job:
dtexec /DTS "\File System\PADashboard_UpdatePackage" /SERVER "WS-BHM-IDP-2" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
1. Where is the \File System\PADashboard_UpdatePackage located? Is it changable outside of SS?
2. Do I need to install SSIS to change the package?