<div>
yes just add the server to enterprise manager then <br />
export / import away ..<br />
<br />
Jay
</div>


yes just add the server to enterprise manager then
export / import away ..

Jay

<div>
Sorry, but no:<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_7d6b.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_7d6b.asp</a><br />
<br />
only dtsrun command line exists to run them from command line
</div>


Sorry, but no:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_7d6b.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_7d6b.asp]

only dtsrun command line exists to run them from command line

<div>
lol ...... Sorry re-read the question angel... all he needs to do is &quot;new database registration&quot; on EM then he can run his wizard all he wants.. <br />
<br />
Jay 
</div>


lol ...... Sorry re-read the question angel... all he needs to do is "new database registration" on EM then he can run his wizard all he wants..

Jay

<div>
If your server is not registered, right click on &quot;SQL Server Group&quot; and select &quot;New SQL Server Registration ...&quot;. &nbsp;Follow the instructions in the wizard to register your server.
</div>


If your server is not registered, right click on "SQL Server Group" and select "New SQL Server Registration ...".  Follow the instructions in the wizard to register your server.

<div>
FYI:<br />
<br />
If you browse down to a specific database on your target server you can right click on it and go to &quot;All Tasks&quot;, then select &quot;Import Data ...&quot; or &quot;Export Data ...&quot;.<br />
<br />
If you do this, it will fill in the appropriate destination or source database info (depending on if you are doing an import or an export).
</div>


FYI:

If you browse down to a specific database on your target server you can right click on it and go to "All Tasks", then select "Import Data ..." or "Export Data ...".

If you do this, it will fill in the appropriate destination or source database info (depending on if you are doing an import or an export).

<div>
<div class="content wysiwyg-content">
Is there anyway to access the DTS Import/Export Wizard without having actual access to the server, i.e. just through Enterprise Manager?
</div>
</div>


Is there anyway to access the DTS Import/Export Wizard without having actual access to the server, i.e. just through Enterprise Manager?

DTS Import/Export Wizard

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.