DTSCopyDatabase Sample

From: Ldraw (Ldraw_at_discussions.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 08:05:02 -0700

I am trying to modify this sample From SQL2000 to copy an Access database to SQL server.
I have tried several different strings for SourceServer and SourceDatabase
but nothing seems to work?

'Customize the Task Object
With oCustomTask
  .Name = "DTSTransferObjectsTask"
  'SourceServer property specifies the name of the source server
  .SourceServer = "(local)"
  'SourceUseTrustedConnection property specifies whether the Windows Authentication security mode is to be used
  .SourceUseTrustedConnection = True
  'SourceDatabase property specifies the name of the source database
  .SourceDatabase = sDatabase1