Answer accepted by question author
As far as I recall, you need to install the SQL Server Integration Services feature, because the wizard relies on these specific components. Start by opening the SQL Server Installation Center from your Start menu or by running your original SQL Server setup media. Once the wizard launches, select the installation tab and choose the option to perform a new SQL Server stand-alone installation or add features to an existing installation.
On the Feature Selection page of the setup wizard, locate and check the box for Integration Services. You do not need to install the full database engine if you already have it - you only need this specific shared feature. Complete the wizard steps to finish the installation. This process places the necessary executable files on your system that SSMS calls when you select those tasks.
Once the installation is complete, you should be able to right-click any database in SQL Server Management Studio, navigate to Tasks, and see the Import Data and Export Data options enabled. If you prefer to launch the tool directly without opening SSMS, you can run the executable from your command prompt or the Run dialog by typing the following path.
"C:\Program Files (x86)\Microsoft SQL Server\160\DTS\Binn\DTSWizard.exe"
If you encounter an architecture error, ensure you are using the 64-bit version of the tool located in the corresponding Program Files folder rather than the x86 directory. This usually resolves any driver mismatch issues when connecting to modern data sources.
If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin
