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. |