Re: Import multiple mdb files to SQL Server issue: Please Help...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello NT,

You can easily convert this package to do what you want

http://www.sqldts.com/246.aspx

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Hi All,
I have about 100+ mdb files with the same table structure design; need
to be
imported into SQL Server. They are in the same directory but
separated
sub-folders (ex: d:\MTS\A1\*.mdb files and d:\MTS\A2\*.mdb
files....d:\MTS\A...n\*mdb files)
I've created the DTS package to import but it handles only one file
for each
package. It's impossible for me to create 100+ DTS packages with the
actual
source filename. Please help, I'm greatly appreciated for your help.
Sincerely



.

Relevant Pages

  • Re: importing xls file - different attempt - one result....
    ... Why not use the wizard to create the exact DTS package you need to import XLS files? ... Dim oConnection as DTS.Connection2 ... Dim oColumn As DTS.Column ...
    (microsoft.public.sqlserver.dts)
  • DTS Package remotely in batch file
    ... the package on the server. ... ECHO The execution of the DTS package has succeeded. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSRun and Batch file
    ... >>refreshed via DTS package, including an Analysis Services task to ... Analysis Services on the client machine. ... So the DTS package is running ... suggesting about implementing a web form or Win form. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSRun and Batch file
    ... >>refreshed via DTS package, including an Analysis Services task to ... Analysis Services on the client machine. ... So the DTS package is running ... suggesting about implementing a web form or Win form. ...
    (microsoft.public.sqlserver.dts)
  • RE: Resuming a failed DTS package - Proper ETL design with DTS package
    ... Somehow I'm supposed to be able to rollback and entire DTS package if it ... You use database transactions to bind multiple updates into a single atomic ...
    (microsoft.public.sqlserver.dts)