Read Text File Into SQL Server 7 Table

[RyanAG]

Working with our ISP host we have a user account set-up(no admin rights) on sql server 7. Every night we have to do a data push to the database of between 50000 to 500 records in five separate tables. Trying to find a stored procedure that will read a text file into a table. Not allowed to use "Bulk Insert" because don't have SYSADMIN rights and believe that is true for DTS also. Is this possible?

Ryan

 

[gcole]

You might be able to run bcp from the command prompt.

 

[tlbroadbent]

Bulk Insert, DTS and BCP don't require sys admin permissions. The database option "select into/bulkcopy" must be set ON to allow these operations. And the login used must have insert permission on the tables. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.