Using SQL Sever Management Studio, I have tried to:
- Right click the database.
- Click "Task".
- Click "Import Data".
However, nothing show up... It used to be working :(
Desperately need a help, please help everyone! thank you so much!!
-
have you tried to close everything? or even restarted your workstation?Ed Bangga– Ed Bangga2019-08-08 02:32:25 +00:00Commented Aug 8, 2019 at 2:32
-
Yes, i have. Still not working :(Sammi Lau– Sammi Lau2019-08-08 03:00:19 +00:00Commented Aug 8, 2019 at 3:00
-
try this execute manually "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTSWizard.exe"Ed Bangga– Ed Bangga2019-08-08 03:02:22 +00:00Commented Aug 8, 2019 at 3:02
-
It poped with "Invalid license data. Reinstall is required." However, i have many database in sql, afraid after reinstall, my data will be gone and time many time to restore data again... :( Do you know any other ways thank you so much!!Sammi Lau– Sammi Lau2019-08-08 03:12:41 +00:00Commented Aug 8, 2019 at 3:12
-
And it shown in SQL: The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate. ------------------------------ ADDITIONAL INFORMATION: Retrieving the COM class factory for component with CLSID {8BF6572D-674B-494E-9047-DDD0E24BB785} failed due to the following error: 8007007e The specified module could not be found. (Exception from HRESULT: 0x8007007E). (DTSWizard)Sammi Lau– Sammi Lau2019-08-08 03:15:16 +00:00Commented Aug 8, 2019 at 3:15
|
Show 1 more comment
1 Answer
Make sure the Import/Export wizard is installed and available (as shown in screenshot), try to restart PC if it's pending from any installation part.
It would be available by default if the SQL services installed, in case not available, you can install it via SSDT
