bulk insert by dynamic file name
===

I try to bulk insert different files.

When i code it like:

    					
	SET @xml=( Select * From OPENROWSET(
					BULK  'C:\Data\csvToXml.xml',SINGLE_BLOB)x)
it is working.

If i take path as parameter like:

         Select @Path 'C:\Data\csvToXml.xml'	


	Select @SqlStmt= N' Select @xmlDoc=( Select * From OPENROWSET(
					BULK '''+@Path+''' ,SINGLE_BLOB)x)'

         exec sp_executesql @SqlStmt, N'@xmlDoc XML',@xmlDoc		
@xmlDoc seems empty. I cannot find where I'm wrong.

Thanks for help.