Visual Studio / SSIS - Import and Export Wizard problem

Question

Hi Guys,

So when I am trying to open up Import and Export Wizard from SSIS Visual Studio project I encounter the following error:

===================================

Object of type 'Microsoft.SqlServer.Management.UI.WizardInputs' cannot be converted to type 'Microsoft.SqlServer.Management.UI.WizardInputs&'. (Microsoft Visual Studio)

------------------------------

Program Location:

at System.RuntimeType.TryChangeType(Object value, Binder binder, CultureInfo culture, Boolean needsSpecialCast)
at System.Reflection.MethodBase.CheckArguments(Object[] parameters, Binder binder, BindingFlags invokeAttr, CultureInfo culture, Signature sig)
at System.Reflection.RuntimeMethodInfo.InvokeArgumentsCheck(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.DataTransformationServices.Wizards.RunDtsWizardTask.RunImportWizard(IWin32Window parentWindow, WizardInputs importWizardInputs)
at Microsoft.DataTransformationServices.Wizards.RunDtsWizardTask.Execute(WizardInputs wizardInputs)

"

Searched the internet but can't really find anything. Import and Export Wizard works on my computer when run directly or from SSMS.

Answer 1

Hi @Szymon Kocejko ,

If you can try to reinstall SSDT, and provide more error log to find the more user information?

Please make sure you have used the latest version of the VS

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Surprisingly it worked. Thanks :)