Jeff ,

I figured it out, I put the set @sql between a begin and an end and excuted via

EXEC (@sql) and it works. For the first time in...

Thanks, for the info, I made the changes and now I am getting this error:

"Could not find stored procedure 'Bulk Insert ...

What did I miss

Thanks again