DBA and SysAdmin World

December 14, 2008

DTSBackup 2000

Filed under: SQL Server — Tags: , , — solihinho @ 3:04 PM
sqldtslogo DTSBackup 2000 is a designed to help with both backup and transfer of DTS package. This version of DTSBackup provides full support for Microsoft SQL Server 2000. New features introduced in this version of DTSBackup include a new DTSBackup file format and direct transfer of packages between SQL Servers. These methods do not suffer the loss of layout information encountered when using the DTS object model.

For further information and download the tool just visit this link.

Beside DTS (Data Transformation Services) tool, there is SSIS (SQL Server Integration Services) tool also. Just visit this link.

Thumps upThis tool has helped me to transfer thousand DTS package when there is a request from developer to get DTS from production and put it into development.Time out After relocate, just check all the package make sure there isn’t  information of production environment such as server name, user and password in development.
Advertisements

2 Comments »

  1. Hi Ho,

    Good article maybe I should apply this to my DTS or SSIS :). Thanks

    Comment by Yanti Yen — April 30, 2009 @ 3:32 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: