Post reply

Execute SQL Task/ Using resultset in data flow

  • February 2, 2009 at 11:50 pm

    #200878

    Hi-

    If i execute a SELECT statement/stored procedure within Execute SQL Task and want to use the access the resultant rows in data flow, the option i could think is store the results or rows fetched in a resultset variable (that has package scope) and use it in data flow.

    can someone tell me the steps to follow to use records from the resultset variable as source for transformations? one way i could i achive this is store the return results from SQL task in a table and use it as source. I want to know how i can do this without using an intermediate table.

    Rgds-

    JJ

  • February 3, 2009 at 8:55 am

    #937202

    Why don't you just run the SELECT/SP from the data flow source?

    So use a OLE DB Source Connection, change the Data access mode to SQL command and ad your SELECT or SP in the SQL command text.

  • February 3, 2009 at 11:54 pm

    #937728

    thanks. I'm still thinking the way i used to with DTS:)

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

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