Exactly how are you importing the file? If this is a DTS Bulk Insert task
or T-SQL BULK INSERT statement, you can specify 'c:/filename' to import a
file that is on the same machine as the SQL Server.
In the case of a DTS Transformation, the path is relative to the machine one
which the DTS package executes. The path is the same as above if the DTS
package is run on the SQL Server.
You can truncate the table in your DTS package with an Execute SQL task that
executes TRUNCATE TABLE. Specify the task a workflow predecessor so that it
runs before your import.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kevin Forbes" <ke*********@yahoo.com> wrote in message
news:25**************************@posting.google.c om...
Hi there,
When importing a text file using SQL Server, how do I specify the path
to a file on the same remote server that SQL Server is running on? I
tried //c:/filename but that doesn't seem to work.
Also, once the import is working, how do I write a DTS package to
first delete all rows in a table, then repopulate with the text file,
or is it easier to drop the table, re-create it and then repopulate?
The table will contain approximately 30,000 records.
thanks for your help,
K