Does the "variable2" exists in the context that you are trying to evaluate? and still exists?

Well, now that i see the error message:

"update email set locator_id = ee.locator_id from...

You could store the query in a variable and evaluate as an expression...

Inside the expression you can format it as you want...

Why you don't put all the things that want to execute in a SequenceContainer and then add a completion constraint to the next task??

What about raising the error?

Use RAISERROR to throw the error:

RAISERROR ( { msg_id | msg_str | @local_variable }

{ ,severity ,state }

[...

Yeap, it the columns in the SS had a bad width, but it wasn't the problem.

The problem was the one that SrikanthSv mentioned:

in ragged right you cannot specify the end...

create the data flow task using import\export wizard.

goto start --- > run ---> type dtswizard ---> select source as flat file ---> and go on ---> in the...