set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

BEGIN

declare @dataareaid as varchar(3)
declare @configpath as varchar(100)
declare @configfile as varchar(100)
declare @configformatfile as varchar(100)


set @configfile = 'C:\ConfigFile\ConfigFileMot.txt'
set @configformatfile = 'C:\ConfigFile\ConfigFormatFile.txt' 

print @dataareaid
print @configpath
print @configfile
print @configformatfile 

exec sp_executesql 
N'select @dataareaid  = dataareaid FROM OPENROWSET( BULK ''' + @configfile + ''', FORMATFILE = ''' + @configformatfile + ''') as a', 
	N'@dataareaid varchar(3) output',  @dataareaid output
select *
FROM AX.[P2].dbo.Dimensions Dim
WHERE Dim.dataareaid = @dataareaid