This is going to sound really silly, but how do I execute a SSIS Package stored on the sql server?
I looked in the help and found this:
dtexec /sq pkgOne /ser productionServer
However, when I run this, I get "Could not find stored procedure 'dtexec'."
Do I need to install something, or is there something I'm missing?
Also, I created the SSIS package, but where is it hiding in the Microsoft SQL Server Management Console?
Thanks in advance!