Re: Import data from multiple acces db
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 11/23/04
- Next message: Darren Green: "Re: Incremental export best practice?"
- Previous message: Muhammad Mansoor: "Inremental Update in DTS"
- In reply to: Import data from multiple acces db: "Import data from multiple acces db"
- Next in thread: Import data from multiple acces db: "Re: Import data from multiple acces db"
- Reply: Import data from multiple acces db: "Re: Import data from multiple acces db"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 13:46:18 -0000
If the structure of the access table is always the same then you can do
this, by changing the connection -
How can I change the filename for an Access Connection?
(http://www.sqldts.com/default.aspx?201)
You could also use the Dynamic Properties Task to do this instead, just use
query assignment to retrieve the value and set the DataSource property of
the MDB connection.
If the table name changes as well, but the structure is the same, then you
could use similar method to above, but change the SourceObjectName property
of the DataPump task as well.
-- Darren Green http://www.sqldts.com "Import data from multiple acces db" <Import data from multiple acces db@discussions.microsoft.com> wrote in message news:77BF6125-A9DA-4C70-B0F9-9D55F037F84B@microsoft.com... > 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
- Next message: Darren Green: "Re: Incremental export best practice?"
- Previous message: Muhammad Mansoor: "Inremental Update in DTS"
- In reply to: Import data from multiple acces db: "Import data from multiple acces db"
- Next in thread: Import data from multiple acces db: "Re: Import data from multiple acces db"
- Reply: Import data from multiple acces db: "Re: Import data from multiple acces db"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
