SQL Server : What is dtsrun Utility?

dtsrun utility executes a package created using Data Transformation
Services (DTS). The DTS package can be stored in the Microsoft SQL
Server msdb database, a COM-structured storage file, or SQL Server
Meta Data Services.

Examples

To execute a DTS package saved as a COM-structured storage file, use:

dtsrun /Ffilename /Npackage_name /Mpackage_password

To execute a DTS package saved in the SQL Server msdb database, use:

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password

To execute a DTS package saved in Meta Data Services, use:

dtsrun /Sserver_name /Uuser_nrame /Ppassword /Npackage_name
/Mpackage_password /Rrepository_name

No comments:

Post a Comment