"Mark Butler" wrote:

> I have a set of text files which are ftp'd to my server daily. I have to
> update these to multiple remote SQL databases. I am linked to these
> databases via a VPN and use the IP address to set up the link to my local
> server. Each of these stored procedures build a work file from these text
> files using a "BULK INSERT" statement as follows.
>
> ------------------------------------
> CREATE PROCEDURE sp_county
> @updates_dir varchar (500)
> AS
> --build the county lookup table
> CREATE TABLE [dbo].[wk_file]
> ([wk_data] [char] (54) NULL)
>
> DECLARE @bulk_insert varchar (500)
> SET @bulk_insert='BULK INSERT wk_file FROM "'+@updates_dir+'county.seq'+'"
> WITH (TABLOCK)'
> EXEC (@bulk_insert)
> ------------------------------------
>
> How can I point the @updates_dir at my server? It seems that I can only
> access local drives to the server with the physical databases. Is there a
> better way I am not seeing? Any insight would be appreciated.
>
> TIA
> Mark
>
>