Home Forums Data Warehousing Integration Services Execute multiple stored procedures using EXECUTE SQL TASK in SSIS 2008 RE: Execute multiple stored procedures using EXECUTE SQL TASK in SSIS 2008

  • I don't believe it's a script error offhand, but would you mind doing a quick test? Can you try only one of the EXEC items in the T-SQL task and see if that succeeds? That will confirm if it's something in the EXEC chain's syntax, or the object's configuration, that's causing an issue.


    - Craig Farrell

    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