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 tables from another db

Status
Not open for further replies.
MTarkington

MTarkington

Programmer
Feb 14, 2001
73
US
Good afternoon,

Using: SQL Server 2k5, Cache v.5

I have tables in Cache that I want to import into SQL Server. My problem is that my SQL server is on a different server than Cache. I can see all of the Windows servers from within the Import Wizard in SQL, but I cannot see the Unix server where the Cache database resides.

Previously, I was using an older version of SQL server on another server and was able to see the Unix server, but due to testing procedures, I am now using another server, but I cannot see the data I want to import.

Any ideas or suggestions?

TIA,
Mark
 
Status
Not open for further replies.

Similar threads

HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
58
HoustonGuy
HoustonGuy
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
283
markjoseph1232
markjoseph1232
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
181
kat50
kat50
ElEye
  • Locked
  • Question
CSV import skips records
Replies
0
Views
60
ElEye
ElEye

Part and Inventory Search

Sponsor

Back
Top