DTS Programming
FoodMart2000
These Microsoft® Visual Basic® samples demonstrate how to use the Visual Basic file output from the Data Transformation Services (DTS) Import/Export Wizard to convert the FoodMart 2000.mdb database to a Microsoft SQL Server™ 2000 database.
There are three samples in this group.
- Foodmart2000a: A .bas file that converts the Foodmart 2000.mdb file to SQL Server 2000.
- Foodmart2000b: A project that converts the Foodmart 2000.mdb file to SQL Server 2000, but shows how to use the DTS package events to indicate process status on UI.
- Foodmart2000c: A .bas file that converts the Foodmart 2000.mdb file to SQL Server 2000, but also incorporates an error handler.
Default Location
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Misc\FoodMart2000
Running the Sample
These samples assume that you are using Windows Authentication and that the execution account has the necessary privileges.
The initial steps for using these samples are:
- Install SQL Server 2000 Analysis Services samples.
- Use SQL Server Enterprise Manager to create a new database called Foodmart2000.
- In FoodMart2000a and FoodMart2000c, modify the path for the DataSourcePath variable name.
- Execute the FoodMart2000a.vdp, FoodMart2000b.vdp, and FoodMart2000c.vdp projects.