Last post Sep 26, 2018 09:03 PM by Sarah_Robert
Sep 26, 2018 07:10 PM|Sarah_Robert|LINK
We have SQL server 2012 on our test servers and I have developed a SSIS package in 2017 with targetServer property set to 2012 on my local machine.
Within the package I have a mergeJoin object. The entire package runs nicely on my local machine, when I set it on test machine which via SQL server agent on 2012, it gives an error saying " To run a SSIS package outside of SQL Server Data Tools you must
install Merge Join of Integration Services or higher"
Integration services is installed on SQL 2012.
Is there a solution to this or if there is a workaround using merge join object, if I can replace with another object.. please suggest.
Sep 26, 2018 09:03 PM|Sarah_Robert|LINK
Ok turned out that the test machine didn't have SSIS installed. Confusion is that there are other jobs using SSIS under SQL server agent that are running successfully on test, just this one with the merge Join is failing.
My conclusion is packages will run under SQL job agent that are simple without heavy work on machine that don't have SSIS installed, but in-order for package to run merge join or "not too straight forward" objects, SSIS has to be installed for a package