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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How do I import from another server?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sync00
Starting Member

24 Posts

Posted - 11/26/2012 :  15:53:11  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 11/27/2012 :  08:31:50  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 11/27/2012 :  10:55:38  Show Profile  Reply with Quote
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?

Edited by - sync00 on 11/27/2012 11:04:38
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 11/27/2012 :  11:45:02  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 11/27/2012 :  13:04:36  Show Profile  Reply with Quote
Neither of the servers have FTP.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 11/27/2012 :  15:17:48  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 11/27/2012 :  16:25:14  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000