Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import ODBC data using local criteria

Status
Not open for further replies.
Beren1h

Beren1h

Technical User
Jul 19, 2001
104
US
Hello all...

Can anyone tell me how to import data from an ODBC data source using criteria in a local table?

What I am looking to do is move records from the ODBC data source (remote Oracle server) to our local SQL server based using a list of SSN we have on our local SQL server. Our list will screen the records we pull in.

Is there a way to build a DTS package to do this?

Thanks...

 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
296
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
356
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
226
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
149
Auguy
Auguy
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
161
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top