When you use BULK INSERT or OPENROWSET(BULK...), it is important to understand how [!INCLUDEssNoVersion] version handles impersonation. For more information, see "Security Considerations," later in ...

description: Find out how to use Transact-SQL statements to bulk import data from a file to a SQL Server or Azure SQL Database table, including security considerations.

My plan was to get the text file and do a Bulk insert into a holder table in Sql server 2000 via the bulk insert command inside a stored procedure.

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.

Batch Inserts using C#, Stored Procs and Sql Server Crazy Diamond Dec 1, 2003 Jump to latest Follow Reply ...