Having Issues with Script task Post Migration from 2008 to 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-908419%22%20slang%3D%22en-US%22%3EHaving%20Issues%20with%20Script%20task%20Post%20Migration%20from%202008%20to%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908419%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EFacing%20issue%20with%20script%20task%20post%20migration%20The%20package%20execution%20gets%20stuck%20at%20the%20script%20task%20step%20when%20executed%20on%20development%20machine%20(Local%20machine)%20can%20someone%20please%20help%20on%20this.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20306px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137153iEB7AFAE18E2E44B4%2Fimage-dimensions%2F306x156%3Fv%3D1.0%22%20width%3D%22306%22%20height%3D%22156%22%20alt%3D%22SSIS%20Package%20Snapshot.JPG%22%20title%3D%22SSIS%20Package%20Snapshot.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909335%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20Issues%20with%20Script%20task%20Post%20Migration%20from%202008%20to%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909335%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20someone%20please%20help%20with%20this%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-943781%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20Issues%20with%20Script%20task%20Post%20Migration%20from%202008%20to%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-943781%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sir%2C%20based%20on%20your%20screenshot%20it's%20hard%20to%20say%20what's%20going%20wrong.%3C%2FP%3E%3CP%3E-%20Is%20your%20connection%20manager%20actual%3C%2FP%3E%3CP%3E-%20Is%20the%20script%20you're%20trying%20to%20execute%20syntax%20correct%3F%3C%2FP%3E%3CP%3E-%20Perhaps%20the%20target%20database%20isn't%20there%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Facing issue with script task post migration The package execution gets stuck at the script task step when executed on development machine (Local machine) can someone please help on this.

 

SSIS Package Snapshot.JPG

2 Replies

can someone please help with this issue.

Hi Sir, based on your screenshot it's hard to say what's going wrong.

- Is your connection manager actual

- Is the script you're trying to execute syntax correct?

- Perhaps the target database isn't there?