dbTalk Databases Forums  

How to Connect remote Ms Access database to SQL SERVER through DTS

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


Discuss How to Connect remote Ms Access database to SQL SERVER through DTS in the microsoft.public.sqlserver.dts forum.



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

Default How to Connect remote Ms Access database to SQL SERVER through DTS - 09-05-2003 , 03:59 AM







Hai,
I want to Convert remote Ms access data to sqlserver
data.

Here i am using FTP Task in DTS for downloading Ms Access
database to local machine.

After that, I convert it to sql data.

In ftp task, I gave ftp address and username,pwd.

When executing package I get operation successfully "with
out" getting downloaded MDB file.

Please give solution for this.

With regards,
Dharmaprakash.

Reply With Quote
Reply




Thread Tools
Display Modes

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.