Re: Import multiple MDB files

hkvats_1999_at_yahoo.com
Date: 06/25/04 

Date: 25 Jun 2004 01:42:36 -0700

Hi Don,

You can create DTS Package which will have AcitveX Script to find MDF
files in network folders.... then you can you further DTS
Transformation to import MDB tables in SQL Server Database.....

You can schedule your DTS Package, by SQL Server Job.....

Other way is that you can DSO Objects to do same task...

Regards
Hari Sharma
Sr. Consultant

Relevant Pages

  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: How is best approach to transform many tables?
    ... >i need to develop a DTS package that uses Oracle8i datanase tables as ... >source and SQL Server 2k tables as target. ... >the source columns are mapped to the target columns (no transformation at ...
    (microsoft.public.sqlserver.dts)
  • Re: export access to sql server
    ... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
    (microsoft.public.vb.general.discussion)
  • Executing a DTS package from a Web application.
    ... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Problem General Network error
    ... Charles Kangai schrieb: ... Author of Learning Tree's 4-day course: "SQL Server 2005 Integration ... email alias: charles ... we are using SISS package (no DTS package sorry). ...
    (microsoft.public.sqlserver.dts)
Loading