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.
| 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 |
 |
|
|
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? |
|
|
|
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 |
|
|
|
sync00
Starting Member
24 Posts |
Posted - 2012-11-27 : 13:04:36
|
| Neither of the servers have FTP. |
|
|
|
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 implicationsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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. |
|
|
|
|
|
|
How do I import from another server?