SQL Server Performance Forum – Threads Archive

Import txt – part I

Hi, I asked about some tips about this problem. But now it’s same. But I haven’t admin rights. I want to import some text file but into sql table without job .

---

Refer this
http://www.nigelrivett.net/SQLTsql/ImportTextFiles.html Madhivanan Failing to plan is Planning to fail

---

I can’t use command xp____cmdShell ..

---

Use DTS, it should be enough to have write permission on database.

---

but I cant use xp_____cmdShell. Only this user can run dts . Am I right ?

---

I’m not sure I understand the question. If you you have an sql or windows account with write permission on that db, you can run dts from your computer in order to import data from txt file. I think no additional permission is necessary to accomplish that.

---

it’s true. But command xp_____cmdShell is very strong . xp___cmdshell is invoked by a user who is a member of the sysadmin . I am only dbo.

---

Hi,<br /><br />I agree with mmarovic, why do the life hard when there is not reason?<br /><br />You can do a dts to import a text file with just two clicks, <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />

---

]]>