Import data from multiple acces db

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Import data from multiple acces db (db_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 01:49:07 -0800

Hi , i need an help .
I need to import data from database access to sql server database , and this
is not a problem . The really problem is that the database access is
variable .
My idea is to insert database location on an sql server table and use this
to change dynamically datasource on my dts .
I try to made a dts but i cannot succeed in .
Can anyone help me and gine me some indication .

I have an sql server 2000 sp3a

Thanks a lot

Relevant Pages

  • Re: Import data from multiple acces db
    ... How can I change the filename for an Access Connection? ... The really problem is that the database access is ... > My idea is to insert database location on an sql server table and use this ... > I try to made a dts but i cannot succeed in. ...
    (microsoft.public.sqlserver.dts)
  • Re: Performance really poor if calling data from sql clients
    ... I can't vouch for any of the VS components when it comes to performance ... since I don't use them for database access. ... profiler to see what is happening on the sql server end. ... Network pack size = 4096 ...
    (microsoft.public.sqlserver.clients)
  • Re: Need Feedback : problem since applying SP2
    ... aspnet_wp.exe recycles itself if there is a lock or memory leak ... > database access after applying .net framework SP2. ... > The error message indicates a security problem for the web ... > server to connect to the SQL server (it says Sql server is ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Need Feedback : problem since applying SP2
    ... database access after applying .net framework SP2. ... I had a couple of web services which exposed SQL server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Sql Server doesnot exist or access denied
    ... // ...do your database access here ... Gomathi wrote: ... My connection string is fine and I am able to log into SQL Server via Enterprise manager ok. ... I have just re-installed .net 1.1 and installed IIS on my local machine. ...
    (microsoft.public.dotnet.framework.adonet)