Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How do I import from another server?

Author  Topic 

sync00
Starting Member

24 Posts

Posted - 2012-11-26 : 15:53:11
I'm creating a DTS Bulk Insert task to import a text file from another server. What do I have to do to get SQL Server to see the other server that contains the file I want to import?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-27 : 08:31:50
Is it on the same network? Can you create a network share ?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

sync00
Starting Member

24 Posts

Posted - 2012-11-27 : 10:55:38
It is on the same network and there is a network share.

I found that if I create a Text File connection I can see the mapped drives on my computer and can create connections to the files I want to import.

However, when I create a Bulk Insert task then I can only see drives on the SQL Server machine. Does this mean I have to map a drive to the server on the SQL Server machine in order to use the Bulk Insert task?
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-27 : 11:45:02
Yes , that is correct. I thought you were initially talking about being on the SQL Server machine and connecting to another server.
Alternatively , can you ftp the text file onto the SQL Server machine?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

sync00
Starting Member

24 Posts

Posted - 2012-11-27 : 13:04:36
Neither of the servers have FTP.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-11-27 : 15:17:48
In that case , the share on the sql server looks like a good option. Before you implement that solution think about any security implications

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

sync00
Starting Member

24 Posts

Posted - 2012-11-27 : 16:25:14
Thanks for your help.

I figured out how to make it work with making any changes on the sql server end. But the bulk insert task is too limited in its configuration options and I ended up using the transform data task.
Go to Top of Page
   

- Advertisement -