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

Hello NT,

What is probably happening is that the step I mention DTSStep_DTSActiveScriptTask_3 is not the same in your package. Go to the Workflow properties and find out the step name of your equivalent step

--

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

Hi Alan,

Thanks for your help...! I finally made it works with the way I wanted
for the single table selected; however, if I selected to import
multiple tables in the mdb file then the following statement from Loop
Around seemed to fail.

set stpbegin = pkg.Steps("DTSStep_DTSActiveScriptTask_3")
'The trick to looping in DTS is to set the step at the start of the
loop to
an execution status of waiting
stpbegin.ExecutionStatus = DTSStepExecStat_Waiting

"NT" wrote:

Hi Allan,

Sorry for the late response, I just got back from my trip. Anyway, It
have not worked yet but I will try again and keep you posted if
you're still interested.

Thanks for your help,
--
NT
"Allan Mitchell" wrote:

Hello NT,

So you have the package looping correctly
You have the Transform Data task set up.
What is the error you get?
--

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

I got your email, thanks for your response...
I know the file extension .res doesn't look like MDB but it is. We
have to
use MS Access 2K or 2003 version to open. I currently have about
200+
.res
files need to be imported onto SQL Server database. These *.res
files
have
been generated from the 3rd party vendor system. There are 10
tables
in each
.res file and all .res files have exactly the same table structure
design,
except the data diff.
I'm very beginner for this task, so I need a lot of help...It's
greatly appreciated for any help.
Best regards,

"Allan Mitchell" wrote:

Hello NT,

Got it thanks. Will look tonight
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com |
http://www.sqldts.com
|
http://www.konesans.com
Please check your email again...

"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)