Listing 1: Script That Initializes Package Global Variables

Function Main()

	' Set the parameters required to initialize a package at runtime.
	DTSGlobalVariables("CopyFoodmartPackage").Value
		=  "d:\demos\sql2000\foodmart\Foodmart Copy Tables.dts"
	DTSGlobalVariables("CopyFoodmartPackageName").Value =  "Foodmart Copy Tables"
	DTSGlobalVariables("PackageGuid").Value= "{D0508D1B-6642-4DDD-8508-2F5DBA726C1A}"

	' Set the Access Database filename and the SQL Server connection parameters.
	DTSGlobalVariables("AccessDbFileName").Value
		=  "C:\Program Files\Microsoft Analysis Services\Samples\Foodmart 2000.mdb"
	DTSGlobalVariables("SQLServerName").Value = "(local)"
	DTSGlobalVariables("DatabaseName").Value = "FoodMart2000"
	DTSGlobalVariables("Username").Value = "sa"
	DTSGlobalVariables("Password").Value=  ""

	' Set the Directory that holds the SQL Server database files.
	Main = DTSTaskExecResult_Success
End Function