question

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 > Import\Auto Import\EandWTest' does not > exist. Make sure that the name is > entered correctly. I am now completely stumped. Any ideas greatfully received. Many thanks