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 |
|
rbrother
Starting Member
1 Post |
 Posted - 2004-03-22 : 08:43:36
|
| I'm using enterprise manager on my client to set up an import job of a remote text file into a remote sqlserver table. I right-click on the table and select all tasks then import data. When I select text file as my "From" data source I'm required to enter a path to the data source. I use "My Network Places" to build the path to the remote text file. When I'm done I get the following path: C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.IE5\SE9VECG2\ImportTextFile[1].txt. Can I use my client enterprise manager or do I have to use terminal services to access the server's enterprise manager? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-23 : 14:26:47
|
| If you are running this manually, and you have permissions to the source file, then you can run it in your own EM. If you want to schedule it as a job, you can build that in your own EM, but it will run under the server's authorization/permissions.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
|
|
|
importing text files into sqlserver tables