Aged Yak Warrior
Posted - 09/11/2013 : 08:05:00
| Hello there, I have mapped a variable in a Execute SQL task,
The parameter name is 0
I am using the below script
declare @fileVariable varchar(100)
declare @file varchar(100)
set @fileVariable = ?
select @file = SUBSTRING (@fileVariable, CHARINDEX('r\cu', @fileVariable) +1, LEN(@fileVariable))
select @file = right(@file, len(@file) -charindex('\', @file))
delete customer_staging where filename = @file
and I get the following error
The query failed to parse. The batch could not be analysed because of compile errors.
The code works fine ssms, could someone point me in the right direction please.