To export the data to SQL2K/DTS, I must first create that database. In this example, I will import data from the STEVENW/pubs database into the SQL2K/DTS database (my test environment contains a default instance of SQL 2000 called STEVENW and a named instance called SQL2K). Let's look at an example of how to use the Import/Export Wizard.
We'll start by looking at the two DTS wizards available within SQL 2000: The DTS wizards in SQL 2000 provide you with the quickest way to move or create packages for data transformation. Once you have mastered the wizards, you can move on the DTS Designer and more advanced topics. To get your hands dirty with DTS, I recommend that you begin by using the DTS wizards. Enhanced logging and a new multiphase data pump.The ability to save packages as Visual Basic files.New FTP, Execute Package, Dynamic Properties, and Message Queue tasks.The ability of packages to run asynchronously.DTS can help you import, export, and/or transform data from various sources to single or multiple locations.ĭTS was first released with SQL Server 7.0 and has been vastly improved with the release of SQL Server 2000. As a result of this, along with the frequent and expected changes made in the average business, it is not unusual to have to move data from one location to another and/or reformat it on a regular basis.Ī powerful set of tools called Data Transformation Services (DTS) can help you perform these tasks in Microsoft SQL Server 2000.
In today’s business world, most companies store their data in different formats. Anything that has to do with how data is stored, saved, updated, and/or deleted will fall into your realm. When administering a database, one of your primary goals is to be the gatekeeper of data.
0 kommentar(er)
