dtswiz Utility

The dtswiz utility allows you to start the Data Transformation Services import and export wizards using command prompt options. The wizards can be used to create Data Transformation Services (DTS) packages that import, export, or transform data between data sources, for example between Microsoft® SQL Server™ and a Microsoft Access database, ASCII text file, or any ODBC data source.

Syntax

dtswiz [{/? | {/n | [/u login_id] [/p password]} [/f filename] {/i | /x}
{/r provider_name | [/s server_name][/d database_name] [/y]}}]

Arguments

/?

Displays the command prompt options.

/n

Specifies Windows NT Authentication (not required). If used, /n takes precedence over /u and /p.

/u login_id

Is a login ID used to connect to SQL Server.

/p password

Is a user-specified password used with a login ID.

/f filename

Saves the DTS package created by the wizard to this COM-structured storage file.

/i

Specifies an import to SQL Server.

/x

Specifies an export from SQL Server.

/r provider_name

Is the name of the provider used to connect to the data source when importing, or the destination when exporting. For example, the Microsoft OLE DB Provider for ODBC is MSDASQL.

/s server_name

Is the server running SQL Server where data is to be exported from or imported to. server_name is the network name of the server. If /f is not specified, the wizard asks if you want to save the DTS package to the SQL Server msdb database.

/d database_name

Is the SQL Server database used to export data from, or import data to.

/y

Hides the SQL Server system databases (master, model, msdb, tempdb). These databases will not show up in the list of source databases when importing data, or the list of destination databases when exporting data.

Remarks

Any number of these options can be used as parameters to the dtswiz command. The DTS Import or DTS Export wizards request any required values not supplied.

The DTS package created can be saved to the SQL Server msdb database, a COM-structured storage file, or the Microsoft Repository.

See Also

Using the Import and Export Wizards