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;
WHILE 1=0
BEGIN
-- Result set for SSIS to use
SELECT
CONVERT(VARCHAR(30), NULL) AS ColumnA,
...
END
... Real code here.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA