Evil Kraig F (3/13/2013)
Most likely they're validating. Turn on Delay Validation.
Also, make sure you're using what's become a defacto standard for SSIS called procs:
SET NOCOUNT ON;
SET FMTONLY OFF;
-- Result set for SSIS to use
CONVERT(VARCHAR(30), NULL) AS ColumnA,
... Real code here.
...unless you're using 2012, in which case the result set definition moves to the Execute SQL task.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.