Hi,

I have tried to do the dinamyc SQL Statement, like this:

Create proc BULK_INSERT_DATA(@PATH varchar(500))

as

declare @SQLStatement as varchar(200)

set nocount on

truncate table bulk_1

SET @SQLStatement = 'BULK INSERT bulk_1

FROM '''+@PATH+'\1.txt''

WITH

(

FIRSTROW =2,

FIELDTERMINATOR =''|'',

ROWTERMINATOR ='''',

tablock,

DATAFILETYPE =''widechar''

)'

execute @SQLStatement

set nocount off

go

BUT This raises an error:

(Could not find stored procedure 'BULK INSERT bulk_Contribuintesest

FROM 'C:\bulk\PastaExportacao SGCTCentral - 20090320 121402_CS\ContribuintesTipo21.txt'

WITH

(

FIRSTROW =2,

FIELDTERMINATOR ='|',

'.)

what is rong with this procedure? can you help please?

In my case i have other BULK Inserts on the same procedure. how can i do it , so that it will all execute? can i do like this?

Create proc BULK_INSERT_DATA(@PATH varchar(500))

as

declare @SQLStatement as varchar(200)

set nocount on

truncate table bulk_1

SET @SQLStatement = 'BULK INSERT bulk_1

FROM '''+@PATH+'\1.txt''

WITH

(

FIRSTROW =2,

FIELDTERMINATOR =''|'',

ROWTERMINATOR ='''',

tablock,

DATAFILETYPE =''widechar''

)'

execute @SQLStatement

truncate table bulk_2

SET @SQLStatement = 'BULK INSERT bulk_2

FROM '''+@PATH+'\2.txt''

WITH

(

FIRSTROW =2,

FIELDTERMINATOR =''|'',

ROWTERMINATOR ='''',

tablock,

DATAFILETYPE =''widechar''

)'

execute @SQLStatement

Tks,

Pedro

set nocount off

go