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

Please check your email again...
--
NT


"Allan Mitchell" wrote:

Hello NT,

remove no-spam

--

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

I have sent to this address allan@xxxxxxxxxxxxxxxxxxx Is it right?

"Allan Mitchell" wrote:

Hello NT,

You will need to modify my eMail slightly to get it to work.

--

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

I'm really bad...I still could not make it work even with a big help
from you. Here is my modification if you would help...Thanks buch!
I sent my .dts to your email

Thanks,

"Allan Mitchell" wrote:

Hello NT,

So your loop simply changes to looping over MDBs
Your assignment of found MDB changes to be a different type of
connection.
You remove the FF --> SQL Server and replace with Access --> SQL
Server
Hopefully this should get you started
--

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

I've used the sample package from http://www.sqldts.com/246.aspx
as you suggested. This package works well for the source data in
flat text format. Unfortunately, in my case that I'm dealing with
the source data in MS Access format. Perhaps, I don't know to
convert this package to work for MS Access files.

Thanks very much if you would get me more and/or better hints on
this issue.

"Allan Mitchell" wrote:

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: Import multiple mdb files to SQL Server issue: Please Help...
    ... I know the file extension .res doesn't look like MDB but it is. ... "Allan Mitchell" wrote: ... I've used the sample package from http://www.sqldts.com/246.aspx ...
    (microsoft.public.sqlserver.dts)
  • Re: Import multiple mdb files to SQL Server issue: Please Help...
    ... "Allan Mitchell" wrote: ... Doing the loop inside the loop is fine but will involve a lot of coding if ... DTSStep_DTSActiveScriptTask_3 to take the next mdb file then do the ... DTSStep_DTSActiveScriptTask_3 is not the same in your package. ...
    (microsoft.public.sqlserver.dts)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: Import multiple mdb files to SQL Server issue: Please Help...
    ... "Allan Mitchell" wrote: ... So you have the package looping correctly ... I know the file extension .res doesn't look like MDB but it is. ... .res file and all .res files have exactly the same table structure ...
    (microsoft.public.sqlserver.dts)
  • Re: Import multiple mdb files to SQL Server issue: Please Help...
    ... "Allan Mitchell" wrote: ... So you have the package looping correctly ... I know the file extension .res doesn't look like MDB but it is. ... .res file and all .res files have exactly the same table structure ...
    (microsoft.public.sqlserver.dts)