Have you tried using a parameter for the filename from with QA. I'm betting that that syntax is not allowed. You can use Dynamic SQL as a work around.

-Mike

>Hi,
>
>I would like to create a SP to execute a BULK INSERT.
>
>If I run the following in QA - it works fine...
>
>

>
>BULK INSERT ATMPOS.dbo.[TransactionDetails]
>   FROM 'd:\testing99.txt'
>   WITH
>      (
>       FIELDTERMINATOR = '|',
>	   KEEPNULLS
>       )
>
>

>
>However, if I try the following, it doesn't work
>
>

>
>declare @PathVC varchar(100)
>
>set @PathVC = 'd:\testing99.txt'
>
>
>BULK INSERT ATMPOS.dbo.[TransactionDetails]
>   FROM @PathVC
>   WITH
>      (
>       FIELDTERMINATOR = '|',
>	   KEEPNULLS
>       )
>
>

>
>
>Can I not use a declared variabe containing the filename and path? Or, is there a better way to do this? I want to execute this from VB6.
>
>Thanks in advance.