Home
%3CLINGO-SUB%20id%3D%22lingo-sub-414518%22%20slang%3D%22en-US%22%3ESSIS%20-%20Package%20Installation%20Wizard%20-%20Next%20button%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3E%3CSTRONG%3EIssue%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERecently%20I%20came%20across%20an%20issue%20where%20the%20Next%20button%20for%20the%20Package%20Installation%20Wizard%20doesn't%20come-up%20(or)%20it%20is%20grayed%20out.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-bottom%3A%20.0001pt%3B%22%3EPlease%20refer%20the%20below%20screenshot%3A%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-bottom%3A%20.0001pt%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20477px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106318iE66C43D0527E3583%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%225.jpg%22%20title%3D%225.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3E%3CSTRONG%3EResolution%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20went%20ahead%20and%20registered%20the%20below%20DLLs%20which%20fixed%20the%20issue%3A%3C%2FP%3E%0A%3CP%3EDTS.dll%3C%2FP%3E%0A%3CP%3EMsDtsSrvrUtil.dll%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%3A%5CWindows%5Csystem32%26gt%3Bregsvr32.exe%20%22C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C%3CVERSION%3E%5CDTS%5CBinn%5CDTS.dll%22%3C%2FVERSION%3E%3C%2FP%3E%0A%3CP%3EC%3A%5CWindows%5Csystem32%26gt%3Bregsvr32.exe%20%22C%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20SQL%20Server%5C%3CVERSION%3E%5CDTS%5CBinn%5CDTS.dll%22%3C%2FVERSION%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%3A%5CWindows%5Csystem32%26gt%3Bregsvr32.exe%20%22C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C%3CVERSION%3E%5CDTS%5CBinn%5CMsDtsSrvrUtil.dll%22%3C%2FVERSION%3E%3C%2FP%3E%0A%3CP%3EC%3A%5CWindows%5Csystem32%26gt%3Bregsvr32.exe%20%22C%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20SQL%20Server%5C%3CVERSION%3E%5CDTS%5CBinn%5CMsDtsSrvrUtil.dll%22%3C%2FVERSION%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAuthor%3A%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3ERanjit%20Mondal%26nbsp%3B%20%E2%80%93%20Support%20Engineer%2C%20SQL%20Server%20BI%20Developer%20team%2C%20Microsoft%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EReviewer%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3EKrishnakumar%20Rukmangathan%20-%20Support%20Escalation%20Engineer%2C%20SQL%20Server%20BI%20Developer%20team%2C%20Microsoft%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-414518%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20SSIS%20-%20Package%20Installation%20wizard%2C%20the%20Next%20button%20doesn't%20come%20up%20or%20it%20is%20grayed%20out.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20477px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106317i610CE229E0E83BCE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%225.jpg%22%20title%3D%225.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPackage%20Installation%20Wizard%20-%20Next%20button%20greyed%20out%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services(SSIS)%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

Issue:

 

Recently I came across an issue where the Next button for the Package Installation Wizard doesn't come-up (or) it is grayed out. 

 

Please refer the below screenshot:

5.jpg

 

Resolution:

 

We went ahead and registered the below DLLs which fixed the issue:

DTS.dll

MsDtsSrvrUtil.dll

 

C:\Windows\system32>regsvr32.exe "C:\Program Files\Microsoft SQL Server\<version>\DTS\Binn\DTS.dll"

C:\Windows\system32>regsvr32.exe "C:\Program Files (x86)\Microsoft SQL Server\<version>\DTS\Binn\DTS.dll"

 

 

C:\Windows\system32>regsvr32.exe "C:\Program Files\Microsoft SQL Server\<version>\DTS\Binn\MsDtsSrvrUtil.dll"

C:\Windows\system32>regsvr32.exe "C:\Program Files (x86)\Microsoft SQL Server\<version>\DTS\Binn\MsDtsSrvrUtil.dll"

 

Author:  Ranjit Mondal  – Support Engineer, SQL Server BI Developer team, Microsoft 

Reviewer: Krishnakumar Rukmangathan - Support Escalation Engineer, SQL Server BI Developer team, Microsoft