sql server dts: I need to extract some data from a client's Access 2000 .mdb with user ID and
Password.

The .mdb is on a PC with a static IP address.

I can log onto the PC with Microsoft's Remote Desktop Connection.

The database is REALLY, REALLY BIG relative to their DSL speed.
Consequently, it is NOT practical to FTP the entire .mdb from the PC to Sql
Server. I need to extract the desired records.

The extraction (and subsequent load) process needs to occur daily to an
ISP's Sql Server.

Can I do this?

How do I specify the IP address of the source machine?

How do I supply the PC login and PWD?

I assume, that if I have a PC connection, that I can supply the .mdb UID and
PWD to simply execute the Sql calls and retrieve the data. Is that correct?

I appreciate any insight.

Thanks,

In message <00369073-EA68-4FE2-9B66-0AEE30EA63D9@microsoft.com>, Abroit
<Abroit@discussions.microsoft.com> writes
[quoted text, click to view]

Access is a file DB, so the process that consumes the file has to be
local, as it will open that file. What you want is SQL Server, that is a
client server RDBS, and does have this issue! Seriously, you will have
to write an interface/process that runs on the client machine and then
extracts the records to a file or even to a SQL server. DTS could do
this but it must be run on the same machine or at least network as MDB,
as the data will need to be local in memory to the process. You cannot
run it on the remote SQL server, but you may be able to connect to the
remote machine, firewalls permitting. Create a package and run it when
logged on through Remote Desktop?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org