Using Variable File Names

[FaStOnE]

How do I use a Variable File Name to do (in this instance) a Bulk Insert from?

**Sample Code**

Declare @Server VarChar( 50)
Declare @Path VarChar(150)
Declare @File VarChar( 50)
Declare @Ext VarChar( 5)

Set @FName = @Server + @Path + @File + @Ext
Bulk Insert db..Table01 From @Fname

Table Table01 is defined as One Column with Varchar(2000)

I get syntax errors on the Bulk Insert Statement.

Any suggestions??

Rick

 

[tlbroadbent]

Use dynamic SQL. The basic syntax is ...

Declare @Server VarChar( 50)
Declare @Path VarChar(150)
Declare @File VarChar( 50)
Declare @Ext VarChar( 5)
Declare @sql varchar(400)

Set @FName = @Server + @Path + @File + @Ext
Set @sql='Bulk Insert db..Table01 From ' + @Fname
Exec(@sql)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.