469,945 Members | 2,270 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

Using DTS to import data - no rows returned.

Hello all. SQL 2000 newbie here. I've done a lot of development in
Access, but the limitations of that program have me looking at upsizing
to SQL 2000.

In my current project I need to import some data on a regular basis
from an Oracle database. I've installed the Oracle client and used the
Import/Export wizard to set up a DTS package to pull in the data. The
query I have in the package works (its rather simple), and going into
the DTS designer I can run the preview and see the relevent data. But
when I execute the package it creates the table in my database, but
with zero rows. Its getting the structure, but isn't pulling over any
of the data.
Anyone willing to help would earn my eternal gratitude. :)

Jul 23 '05 #1
4 2007
JD
Maddman,
Are you getting any type of errors? What do your logs show?
"Maddman" <ma********@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Hello all. SQL 2000 newbie here. I've done a lot of development in
Access, but the limitations of that program have me looking at upsizing
to SQL 2000.

In my current project I need to import some data on a regular basis
from an Oracle database. I've installed the Oracle client and used the
Import/Export wizard to set up a DTS package to pull in the data. The
query I have in the package works (its rather simple), and going into
the DTS designer I can run the preview and see the relevent data. But
when I execute the package it creates the table in my database, but
with zero rows. Its getting the structure, but isn't pulling over any
of the data.
Anyone willing to help would earn my eternal gratitude. :)

Jul 23 '05 #2
I'm not getting any errors, it reports that the process completed
successfully. There's nothing in the logs that indicates anything out
of the ordinary. The only entry for the current day is

Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_msver'.

Jul 23 '05 #3
I'm not getting any errors, it reports that the process completed
successfully. There's nothing in the logs that indicates anything out
of the ordinary. The only entry for the current day is

Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_msver'.

Jul 23 '05 #4
I'm not getting any errors, it reports that the process completed
successfully. There's nothing in the logs that indicates anything out
of the ordinary. The only entry for the current day is

Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_msver'.

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by frankentux | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.