Where do I install the necessary files to get the import/export wizard to show up in sql express management studio? I have tried installing the SP1 Toolkit, the advanced services etc but I cannot get it so that I can right click on a database and 'import data' or 'export data'
Thanks!
I am not sure but because Management studio express is for express database which does not support SSIS services and SQL agent which are used for export/import by wizard this option was removed from user interface.
Sorry
|||
It does not show up on the UI but I found it in this directory
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe
I think it comes with the Toolkit download
Tony
No comments:
Post a Comment