locked
import/export with SQL Server Management Studio RRS feed

  • Question

  •  

    I recently started using SQL Server Management Studio and I do not have the import/export option under all tasks.  Is this because SSIS was not installed. Can I download and install just the DTS system?

     

    Thanks.

    Marc

    Wednesday, August 2, 2006 1:50 AM

Answers

  • hi,

    so your saying if you right-click a DB name in mgt studio, then select 'Tasks' you do not have options for "Import data" and "Export Data"?

    You can install just the SQL Server Integration Services (SSIS) from the SQLmedia.  SSIS is one option during SQL install.

    Friday, August 4, 2006 11:27 PM