I think you're talking about the SendAndExecute method... as part of the SQLCommand obj,

I realize the performance differences you are talking about, however I'm sort of creating a package that...

I figured it out, I'm just tired and apparently blind.

nothing was wrong with my code, I was just entering the datetime data without single quotes.