I have a Connection in WEB SQL SERVER.

I need Connection from this SQL SERVER DTS to another
Webserver Ms Access database for converting access
database to SQL database.

Now I am using FTP task in DTS package for downloading the
Ms Access database to Local machine.
Now I will connect this database to SQL DATABase.

but What I have problem is, I cann't get a Downloaded MDB
file from Webserver.
I gave userId and Password for FTP Connection. I have not
any Error message. I got only Successful message.

What is the problem in my connection?

Is there any way to Convert ms access to SQL database
using DTS or other tool?

Please give me a Suggession.

Thanks in Advance

With regards,
Prakash.

Can you simply not have a UNC path to the Access MDB ?
Forget about DTS for a second. Using FTP.exe can you get the Access DB down
to the local PC?



--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

UNC is a method whereby istead of saying "c:\MyAccessDb.mdb" you can say
"\\ServerName\ShareName\FileName". It means that the file(s) can be found
from any computer the package is run on. It stops you having to map drives
as again this is problematic. In your DTS package then you specify the
location of the Access DB in the Access connection using UNC. You will need
to set up a share on the remote computer accessible by the accounts you
need.



--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org