SSIS Variable in Execute SQL Task to Drop SQL Server Login
Posted on 2013-01-08
I have a requirement where I need to drop SQL Server Login using SSIS SQL Task and SSIS variables.
DROP LOGIN ?
while input parameter is setup against ? i.e., LoginName.
When I run the package it says there is a syntax error after '?'
Any comments and suggestions are appreciated.