Good question, got it it right due to previously having some troubles with this. I wanted to respond to again bump the quoted post below as i think it's...

I'm not sure what to tell you other than depending on what control object you are right clicking on you may not have that option.

But if you were to click...

If you right click on the step in the Control Flow tab, it allows you to "Execute Task". This will only execute the specific step you are on. ...

couldn't you just read in that input, then pass your data through a derived column flow, and use the cast operations to convert your data?

I've not had problems with config file not being used. Just make sure that on top of creating the config file while editing the package, that you also choose...

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '<'.

Agree with others, i'm so used to taking things verbatim that i kinda wondered if it was a trick question,...