Post reply

Getting data from ADO Recordset

  • December 30, 2009 at 11:06 am

    #215356

    Hi Guys!

    I need your help and urgent. I have an SSIS package with DataFlow task which populates ADO recordset. Next step should be using this recordset, but i cannot even run a simple select from this relcordset.

    I'm writing into variable with Object data type but then in Execute SQL task i cannot setup proper parameter mappings and i can't write proper select statement for that recordset.

    These are columns from the recordset:

    [PrincipalJobName] [nvarchar](128) NOT NULL,

    [DependentJobName] [nvarchar](128) NOT NULL,

    [DependentCurrentRunStatus] [int] NULL

    Please help

  • January 1, 2010 at 9:43 am

    #1098093

    Lazy way

    var_dump($myrow );

    Lazy but visually attractive - rs2html in Adodb I understand PEAR has a datagrid as well.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • January 1, 2010 at 1:48 pm

    #1098124

    This is a Microsoft How To that you might find useful. It works. Obviously, you can replace the Send Mail Task with the ExecuteSQL task.

    How to: Use a Recordset Destination

  • January 5, 2010 at 1:41 pm

    #1099218

    Can you tell us what you plan to do with the rows inside the recordset?

    The Recordset destination was not designed to pass data between tasks. Use the Raw File Destination to do this.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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