Dynamic SQL to run Bulk Insert

Hi, I wonder if anyone can help. I am creating dynamic SQL using variables so that I can use the same script for various imports.

The script is:

DECLARE @sSourceType AS VARCHAR(10)
DECLARE @sPath AS VARCHAR(50)
DECLARE @sFileName AS VARCHAR(50)
DECLARE @sSourceTableName AS VARCHAR(50)
DECLARE @sSourceFMTFile AS VARCHAR(50)
DECLARE @iSourceID AS INT
DECLARE @SQL AS VARCHAR(500)

SET @iSourceID = (SELECT TOP 1 iID FROM dbo.SX_SourceFiles WHERE iID NOT IN (SELECT iSourceID FROM SX_ImportHold))
SET @sPath = (SELECT TOP 1 sPath FROM dbo.SX_SourceFiles WHERE iID NOT IN (SELECT iSourceID FROM SX_ImportHold))
SET @sFileName = (SELECT TOP 1 sFileName FROM SX_SourceFiles WHERE iID NOT IN (SELECT iSourceID FROM SX_ImportHold))
SET @sSourceTableName = (SELECT TOP 1 sSourceTableName FROM dbo.SX_SourceFiles WHERE iID NOT IN (SELECT iSourceID FROM SX_ImportHold))
SET @sSourceFMTFile = (SELECT TOP 1 sSourceFMTFile FROM dbo.SX_SourceFiles WHERE iID NOT IN (SELECT iSourceID FROM SX_ImportHold))

PRINT @sSourceTableName

EXEC ('Truncate table ' + @sSourceTableName )
PRINT  @sSourceTableName + ' has been truncated'

SET @SQL = 
('BULK INSERT ' + @sSourceTableName + '
FROM ''' + @sPath + @sFileName + '''
WITH (FORMATFILE = ''' + @sSourceFMTFile + ''')')

EXEC @SQL

When you copy the printed script which looks like this:

BULK INSERT PriceImportHoldingEW
FROM 'C:\Auto Import\Auto Import\EandWTest.txt'
WITH (FORMATFILE = 'C:\Auto Import\EandWFormatFile.fmt')

It works fine, but when you to try to execute it within the script is has the error message:

Msg 911, Level 16, State 4, Line 27 Database 'BULK INSERT PriceImportHoldingEW FROM 'C:Auto ImportAuto ImportEandWTest' does not exist. Make sure that the name is entered correctly.

I am now completely stumped. Any ideas greatfully received.

Many thanks