ssis 2012 Script Task RRS feed

  • Question

  • Script Task executes locally. When run thru DTSEXEC fails with "must install SSIS". However, SSIS is installed as there are 20 other packages that run fine. It's only the packages that use the script task that fail. I've checked to make sure VSTA30 was installed - it is. 

    This is a conversion from SQL 2008 to SQL 2012, running on Windows 2012.  Is there something I missed?

    Wednesday, June 11, 2014 1:27 PM


  • Locally means what?

    Perhaps you run the wrong version of dtexec because you have both, SSIS 2008 and 2012 on the same machine

    Arthur My Blog

    • Proposed as answer by Mike Yin Tuesday, June 17, 2014 8:45 AM
    • Marked as answer by Mike Yin Thursday, June 19, 2014 5:09 PM
    Wednesday, June 11, 2014 3:05 PM