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:

1. Install SQL Server 2000 Analysis Services samples.
   
   
2. Use SQL Server Enterprise Manager to create a new database called Foodmart2000.
   
   
3. In FoodMart2000a and FoodMart2000c, modify the path for the DataSourcePath variable name.
   
   
4. Execute the FoodMart2000a.vdp, FoodMart2000b.vdp, and FoodMart2000c.vdp projects.

See Also

DTS Programming Samples