Importing a TextFile, best way
I want to import a textfile (approx 5mb) into a SQL Server table on a regular basis.
The way I am doing this at the moment is via a DTS package, where I delete a base table and import the new data. This works but my transaction log has grown 200Mb,
I have looked at Bulk Insert within DTS, but assume this creates a table each time, therefore my base table with indexes in will be lost.
My problem is the Tran Log, whats the best practice to delete this log or stop it growing. The freshly created base table is used only for reporting off.