dbTalk Databases Forums  

Re: DTSCopyDatabase Sample

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Re: DTSCopyDatabase Sample

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: DTSCopyDatabase Sample in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTSCopyDatabase Sample - 07-19-2004 , 10:37 AM





The CopyDatabase task will not work against Access.

Have a look here in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\adm
insql.chm::/ad_onmigwiz_0z50.htm

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Ldraw" <Ldraw (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top