SSIS_ExecuteSQLTask passing object type variable as input

  • I want to pass object type variable as input in next execute sql task. In parameter mapping what data type should i use to map with "?" in my sql statement.

  • In the Result Set tab set Result Name to 0 and select my System.Object variable (this will end up holding an ADO Recordset)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply